Fax Software

Community Forums

This topic contains 3 replies, has 0 voices, and was last updated by  chatty 9 years, 6 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #3113

    chatty
    Member

    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?

    #5846

    JohnD
    Participant

    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.

    #5847

    admin
    Keymaster

    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

    #5848

    chatty
    Member

    Thanks for that, I’ll give it try

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.