Hi there, hope somebody can help or advise:
I have the following code associated with a button on a form which should save and close an excel file:
I also have the following code in the Thisworkbook Object which replicates some of what the button referred to above does (the below was not working for some reason so I placed the same code into the button to ensure it runs).
For some reason Excel 2010 crashes about 20% to 50% of the time when I use the button to close the Excel file. I'd be grateful in anyone could advise me as to what might be causing this. Perhaps it might also help if I say that the Excel file is saved as a 2003 (.xls) file as it needs to run on other computers operating Excel 2003, and that I generally find Excel 2010 to be more unstable that 2003.
Many thanks
Is
Bookmarks