Sage Accpac Community
Accpac Support Community
Search in

ACCPAC Ver. 5.2 CA_BLE Macro ( *.MAC ) ... Need a Page Number

Last post Thu, Aug 27 2009 5:12 PM by Ettienne Schwagele. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • Wed, Aug 26 2009 5:48 PM

    • RJL
    • Top 50 Contributor
    • Joined on Thu, Oct 2 2008
    • Posts 14

    ACCPAC Ver. 5.2 CA_BLE Macro ( *.MAC ) ... Need a Page Number

     We are currently using Accpac Ver. 5.2 and running some macros ( *.mac ) to

    print a group of G/L Financial Statements ..... I need to know how to add a page # to

    the printouts.

    Thank you in advance for your help.

     

     

  • Wed, Aug 26 2009 7:06 PM In reply to

    Re: ACCPAC Ver. 5.2 CA_BLE Macro ( *.MAC ) ... Need a Page Number

    Edit the spreadsheets, and add it to the header or the footer.

  • Wed, Aug 26 2009 7:07 PM In reply to

    Re: ACCPAC Ver. 5.2 CA_BLE Macro ( *.MAC ) ... Need a Page Number

    You can add the page numbers to each FR in Excel using the Custom Footer in Print Preview Page Setup.

  • Thu, Aug 27 2009 5:05 PM In reply to

    • RJL
    • Top 50 Contributor
    • Joined on Thu, Oct 2 2008
    • Posts 14

    Re: ACCPAC Ver. 5.2 CA_BLE Macro ( *.MAC ) ... Need a Page Number

     Thank you for the reply Jay and Ettienne ..... However, the macro contains several Fin. Specs. to be run consecutively and the solution you suggested ( setting a page # in each of the Excel Specs. ) only sets the page # for individual specs. ie. The page #'s start over at 1 for each new Fin. Spec. that is printed.

    What I was hoping to find was a command in the macro that would # all the pages sequentially.

    Could this be done if the macro was a VB macro rather than a CA_BLE macro ?

    Thank you again.

     

  • Thu, Aug 27 2009 5:12 PM In reply to

    Re: ACCPAC Ver. 5.2 CA_BLE Macro ( *.MAC ) ... Need a Page Number

    Nope it cannot be done, not in VBA or Cable.

Page 1 of 1 (5 items)