- This topic is empty.
-
AuthorPosts
-
May 4, 2009 at 1:17 pm #3113
chatty
MemberI have got WFP 10.03 to sort of work using the wfx macro for Excel 2000, but when the macro runs, it tries to fax all the sheets in the workbook instead of just the active sheet. I have defined a print area but it makes no difference. Can anyone help?
May 4, 2009 at 4:12 pm #5846JohnD
ParticipantI don’t recall as it has been a number of years since i’ve used the Excel macro, but I believe it always print the entire workbook when it issues the print to WinFax command.
May 6, 2009 at 4:56 pm #5847Administrator
KeymasterThis is possible but you will have to modify the Excel code in the original macro to print the selection instead of the entire workbook.
The code in the macro uses “ActiveWorkbook.PrintOut”
which prints the entire workbook.so, you would have to change this line to whatever you want to do.
Examples:ActiveWorkbook.PrintOut
‘the whole workbookWorksheets.PrintOut
‘all worksheetsSheets.PrintOut
‘all sheetsSheets(Array(“Sheet1”, “Sheet3”)).PrintOut
‘all sheets in the arrayActiveWindow.SelectedSheets.PrintOut
‘print all selected sheetsActiveSheet.PrintOut
‘only the activesheetSheets(“Sheet1”).PrintOut
‘only “Sheet1”Selection.PrintOut
‘print only the selectionRange(“C1:D5”).PrintOut
‘print rangeJune 4, 2009 at 9:18 am #5848chatty
MemberThanks for that, I’ll give it try
-
AuthorPosts
- You must be logged in to reply to this topic.