View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent Burkart Brent Burkart is offline
external usenet poster
 
Posts: 3
Default PrintToFile OutputFilename problems

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