I have a set of sheets in a spreadsheet doc that contain data plots that I
want to print to a file where the file name is based on the sheet name.
The print ranges for each sheet have been set such that only the plots will
be printed.
I have For loop that does...
For i = Lbound(SheetNames()) To Ubound(SheetNames())
<update sheet data and plot data range to include new sheet data>
PrintChart(SheetNames(i))
Next i
Right now the PrintChart routine simply does ThisComponent.Print(Array())
and I get the plots printed on paper from my printer.
I would like to have it do a 'print to file' with the file name set to
something like /the/path/to/<SheetName>.ps but I can't figure out how to
specify the 'print to file' option and the file path name.
Anyone have any hints on how to do this?
Thanks
Craig Johnson
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
