PrintToFile OutputFilename problems

[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

 

[Ron de Bruin]

Try this Brent

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

 

[Bob Phillips]

My version of Excel (XL2000) doesn't have a OutputFilename parameter, it has
a PrToFileName parameter for the filename.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Brent Burkart]

That was it!
Thanks

Try this Brent

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

 

[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