I have a Spreadsheet with a macro that sorts the records, makes the Header Bold, etc. Automation does run the macro (I see that the header is bold) however it does not sort the records. If I manually run the macro after the export is completed the records are sorted. The command to run the macro is in the OnPostReport trigger before the Save Command. What can I do to solve the problem?
Is this two separate macros or just one?
quote:
Is this two separate macros or just one? Just one I have found the real problem, namely the macro did not run. now that I invoke it correctly as follows: MyMacro :=‘SortByLoc’; xlApp.run(MyMacro); All is well. Thank you.
Originally posted by CMDunbar - 2005 Nov 18 : 16:30:53