Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That seems to work, however, its attempting to print to my default printer.
Should I have the parameter "ActivePrinter" set to anything? Thanks, Brent "Ron de Bruin" wrote in message ... Try this Brent Selection.PrintOut PrintToFile:=True, PrToFileName:="c:\fundings.prn" -- Regards Ron de Bruin http://www.rondebruin.nl "Brent Burkart" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Sum problems | Excel Worksheet Functions | |||
Problems with IRM | Charts and Charting in Excel | |||
tab problems | New Users to Excel | |||
PrintToFile param - what's the file format? | Excel Programming |