Hello everybody,
I thought this forum or even Google could help me, but in fact I'm just getting wrong search results for slighty different topics.
My problem is: I have a VBA-code that copies an Excel-sheet, saves it separately and sends it via MS Outlook. I'm working with Windows 7 and Excel version 2007. The copy of the excel-sheet is to be sent to different receivers - some of them use Excel 2003, some use 2007 or higher.
However, when I want to save the copy as an .xls file for the Excel 2003 users, an error occurs telling me, that something might go wrong and whether I wanted Excel to recalculate all cells the next time the worksheet will be opened.
The code is to send 100 copies each time you hit "send", so it will give me 60 or more error messages for all excel 2003 users.
I want the code to automatically "click no" for the appearing message.
How could I implement that?
Is there something like "Error.MsgBox = vbNo"?
Thank you so much!
I thought this forum or even Google could help me, but in fact I'm just getting wrong search results for slighty different topics.
My problem is: I have a VBA-code that copies an Excel-sheet, saves it separately and sends it via MS Outlook. I'm working with Windows 7 and Excel version 2007. The copy of the excel-sheet is to be sent to different receivers - some of them use Excel 2003, some use 2007 or higher.
However, when I want to save the copy as an .xls file for the Excel 2003 users, an error occurs telling me, that something might go wrong and whether I wanted Excel to recalculate all cells the next time the worksheet will be opened.
The code is to send 100 copies each time you hit "send", so it will give me 60 or more error messages for all excel 2003 users.
I want the code to automatically "click no" for the appearing message.
How could I implement that?
Is there something like "Error.MsgBox = vbNo"?
Thank you so much!