Prev: How do you count the number of * in a string?
Next: centering text on textbox
From: Mathieu Normandeau Mathieu on 14 Jan 2010 09:29
Hi,
A server has Excel 1997 installed and cannot be upgraded for compatibility
reason.
I need to automated a process to create a PDF file (with a printer driver).
The printer driver need the parameter "Print to file name" (PrToFileName).
It seem that the printout function does not have that parameter in Excel 1997.

Is there any way I can do it?

Thanks,
From: ker_01 on 14 Jan 2010 15:45
The best approach may depend on the printer driver itself (is it Adobe, and
if so what version, etc.).

However, there is a simple solution that I used back when I was on 97 and (I
think) Adobe 4(?).

I couldn't force an output name, so I sent the file to the print driver, set
a timer for 5 seconds (which was long enough for my document(s) to process),
then I just renamed the file- I already knew what directory it was going to
land in, and the filename was the standard PDF output name (whatever that
was).

Name C:\standardname.pdf C:\MyPath\Myfilename.pdf

where you would presumably hardcode the first path and filename, then use a
constant for your new path, and a variable for your new filename, so
something more like

Constant StandardName = "C:\StandardName.pdf"
Constant MyNewPath = "C:\My Analytics\"
Constant pdfextension = ".pdf"

for i = 1 to 3
'insert a timer that is long enough to produce your file on your PC
MyFileName = "Here is my filename " & i & pdfextension
Name Standardname MyNewPath & MyFilename & pdfextension
Next i

HTH,
Keith


"Mathieu Normandeau" wrote:

> Hi,
> A server has Excel 1997 installed and cannot be upgraded for compatibility
> reason.
> I need to automated a process to create a PDF file (with a printer driver).
> The printer driver need the parameter "Print to file name" (PrToFileName).
> It seem that the printout function does not have that parameter in Excel 1997.
>
> Is there any way I can do it?
>
> Thanks,
 | 
Pages: 1
Prev: How do you count the number of * in a string?
Next: centering text on textbox