Sage Home    Go to sage.com
Sage 300 ERP Community
Accpac Support Community
Home Blogs Forums Knowledgebase Resources Your Feedback
Search in

Sage ERP 500 open excel macro file?

Sage 300 ERP Community » Sage 300 ERP [Accpac] » General Discussion » Sage ERP 500 open excel macro file?
Last post Wed, Aug 1 2012 2:06 PM by anhlunnhaque. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • Wed, Aug 1 2012 9:45 AM

    Sage ERP 500 open excel macro file?

    Reply Contact

    Hello,

     

    I am a newbie at Accpac application. And I am not sure if this is the right forum. But I am trying to learn how to use it and I was wondering if Accpac 500 can open an excel macro file within Accpac. I know it can open a .rpt file store in it, but is there a way for Accpac to store and open (.xlsm/xls) macro?

     

    Thanks,

    Ekin

  • Wed, Aug 1 2012 10:23 AM In reply to

    Re: Sage ERP 500 open excel macro file?

    Reply Contact

    Accpac supports Microsoft VBA, the same macro language that Excel uses.

    You can record VBA macros in Accpac (Macro, Start Recording / Stop Recording) and you can edit VBA macros (Macro, Edit) and modify the recorded macros to perform the tasks you require.

    You can open Excel files via Accpac VBA and possibly run Excel macros, I have never done this because I have no need to do so - I will leave this up to you to test if you wish to do so.

    My best advise is to work within Accpac VBA macros instead of attempting to run Excel macros within Accpac - that just adds a layer of complexity.

    You can add desktop shortcuts to Excel files on the Accpac desktop (Object, New, Program and select the Excel file) and open Excel files from within Accpac, if your Excel macros are set to autorun then they will run when the Excel files are opened - dunno if that is what you are looking for.

  • Wed, Aug 1 2012 2:06 PM In reply to

    Re: Sage ERP 500 open excel macro file?

    Reply Contact

    Yes, that's exactly what I am looking for. Thank you for the help.
Page 1 of 1 (3 items)