PrintToFile OutputFilename problems

B

Brent Burkart

I am trying to print to a file using the following line of code.

Selection.PrintOut PrintToFile:=True, OutputFilename:="c:\fundings.prn"

This bombs out with a error:

Run-time error '1004'
Application-defined or object-defined error

It works if I remove the "OutputFilename" parameter and enter manually at
the prompt, however, I want to automate the outputfilename parameter.

Has anyone seen this or do you have any ideas as to what I am doing wrong?

Thanks,
Brent
 
R

Ron de Bruin

Try this Brent

Selection.PrintOut PrintToFile:=True, PrToFileName:="c:\fundings.prn"
 
B

Brent Burkart

That seems to work, however, its attempting to print to my default printer.
Should I have the parameter "ActivePrinter" set to anything?

Thanks,
Brent
 
Top