Hello all
I'm creating reports from SIMS using the process where you take a copy of ReportData.xls and add code to the AutoOpen macro to make it do fancy stuff... I'm ok with all that, when it works it does what I'm expecting (or if I've cocked up in the code, it fails in the way I'm expecting).
Where I'm struggling is that I don't really understand what is going on in terms of where ExcelList.xls comes into the equation! It causes me all sorts of trouble with sticking open when it shouldn't.
I'm also getting the problem where Excel will run - not get to the point where my code starts, and then closes without any errors or goodbyes! Sometimes that's fixed by a restart of SIMS, sometimes by a restart of the machine, sometimes by a cup of tea!
Does anyone have a clear explanation of what is actually going on? I appreciate that the report is kicking of the AutoOpen macro but I can't work out where ExcelList comes from, when it's created, how or why
Thanks
Lou
