Hi All
I was of the understanding that events in the Workbook module should run sequentially, however I have the following code which is stalling after the Sub 'PensionPriceDataExport'
Basically the subs import a list of price data in CSV format, then after running some manual calculation, they export certain output data into a local directory as a csv, then purge all the data in each tab, and start the process again, but with a new index of fund price data.
I used to run these events as an 'x minutes after workbook open' routine, with several minutes wait between each event, but I was told there was no reason to do this, and the next should execute after completion of the previous...
Here's the code from This Workbook
The sub stalls after the first 'PensionPriceDataExport' has completed.
The code for 'PurgeDataAuto' has basically been added onto the end of the previous sub, but either way, whether it is a standalone sub or the code is incorporated into the previous sub, after purging the data from the worksheets, it then stalls and is unable to continue to IndexListImporter again. (Which as you can see, it loads several times...)
Is there anything obvious I am missing here? Is it related to running the same sub several times? (I.e. it is ignoring it, because it is of the same name...)
Many thanks for your help
Bookmarks