[chatty]

I 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?

[JohnD]

I 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.

[Administrator]

This 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 workbook

Worksheets.PrintOut
‘all worksheets

Sheets.PrintOut
‘all sheets

Sheets(Array(“Sheet1”, “Sheet3”)).PrintOut
‘all sheets in the array

ActiveWindow.SelectedSheets.PrintOut
‘print all selected sheets

ActiveSheet.PrintOut
‘only the activesheet

Sheets(“Sheet1”).PrintOut
‘only “Sheet1”

Selection.PrintOut
‘print only the selection

Range(“C1:D5”).PrintOut
‘print range

[chatty]

Thanks for that, I’ll give it try

[Author]

Posts