VBA troubleshooting on Office Excel/WOrd/SharePoint
Budget: $30 – $250 USD
I have an excel workbook on sharepoint that runs a macro that launches a mail merge routine from a Word Template also on sharepoint. There is a macro in Excel that calls a routine in the WOrd document. I have had to change this routine, but have introduced an error that I need help correcting.
The problem that I have is that although the Excel macro appears to be running running correctly, when the WOrd macro starts it is using the wrong sheet to merge. I have noticed that when I do a manual mail merge from the Word document there are a large number of tables in the Excel file and the first one on the list is the table that the Word marco seems to be using (Cancelled courses).
Program Master.xls (LaunchCreateGoPack is the macro), Master is the sheet I am invoking the macro from)
GoPack_Boiler-LRG.docm (CreateGoPack is the macro)
I would like someone to troubleshoot and correct the macros so that they run correctly.
The problem that I have is that although the Excel macro appears to be running running correctly, when the WOrd macro starts it is using the wrong sheet to merge. I have noticed that when I do a manual mail merge from the Word document there are a large number of tables in the Excel file and the first one on the list is the table that the Word marco seems to be using (Cancelled courses).
Program Master.xls (LaunchCreateGoPack is the macro), Master is the sheet I am invoking the macro from)
GoPack_Boiler-LRG.docm (CreateGoPack is the macro)
I would like someone to troubleshoot and correct the macros so that they run correctly.