Search results for query: *

I need to use an Accpac V5.5 macro to import GL transactions into a GL batch. I have compiled the following macro code but it does not work. The XML script reference in the macro code is correct as I can use the Accpac GL Import/Export function to load the XML script and perform the import that...

The problem I had was solved by referencing the Accpac Signon Manager and Accpac Session Manager and forcing some Accpac Signoffs. The coding below works a treat for me. The macros operate out of an Excel file. There are actually twenty databases in the live version (the code below shows two...

Thanks to every respondee.Based on your responses and other related posts in the Accpac forum I have coded up a rough solution this morning. I'll post it later today.

Could you please suggest the code I need for identify/set the "SessionID". Thanks.

Appreciate any responses - I thought that as well. At this stage I have created a macro for each database/FR report required by the Excel file. The following code is used at start of each macro to open the required Accpac session/database: Dim Session As New AccpacCOMAPI.AccpacSession Dim...

I have an Excel spreadsheet with a macro that needs to open an Accpac V5.5 (MSQL) database, generate a FR report to file, close the database and then sequentially repeat the process to another five databases. based on testing my macro code works fine for the first database connection only - it...