kevkni
07-23-2012, 06:21 AM
Hi,
I'm trying to run an excel macro but at various stages it ends up causing MS Excel to crash.
The macro essentially opens an Excel file which is a blank cashflow template, saves the excel document as a new file with the name of the organisation in the filename, opens an older version of that particular organisations cashflow file, performs a series of "copy and paste" functions from the old template to the new template, and then saves and closes the template.
The macro then works it way down a list of organisation names, repeating the above process.
Sometimes the macro will reach the 5th or 6th organisation before Excel crashes, sometimes it will crash further down the list.
I've stepped through the macro line-by-line, and successfully completed the macro from start to finish without Excel crashing, but when it just "runs", it crashes.
Please can somebody help explain why this is happening!? :banghead:
Thanks
Kevin
I'm trying to run an excel macro but at various stages it ends up causing MS Excel to crash.
The macro essentially opens an Excel file which is a blank cashflow template, saves the excel document as a new file with the name of the organisation in the filename, opens an older version of that particular organisations cashflow file, performs a series of "copy and paste" functions from the old template to the new template, and then saves and closes the template.
The macro then works it way down a list of organisation names, repeating the above process.
Sometimes the macro will reach the 5th or 6th organisation before Excel crashes, sometimes it will crash further down the list.
I've stepped through the macro line-by-line, and successfully completed the macro from start to finish without Excel crashing, but when it just "runs", it crashes.
Please can somebody help explain why this is happening!? :banghead:
Thanks
Kevin