Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help printing to a file.
I am trying to understand code written by someone else (who is not available). I am using the Immediate Window, but this Window only holds a limited amount of information. I have inserted "Stop" commands, but I've gotten confused trying to follow the code's logic. I've inserted a LOT of Debug.print commands. Now, I'd like to just print all the information to a file and study the file. I've tried the following code: ActiveSheet.PrintOut and the worksheet is printed on the printer. Then I tried the following code: ActiveSheet.PrintOut printtofile:=True, prtofilename:="Print Out Method Example.txt" VBA created the fle, but I do not get anything from the worksheet. I do get all of the driver setup information for every printer on the LAN I have access to. Does anyone have any suggestions? Thanks in advance, Shorty |