SaveAs xlsb

[sparx]

Hi all, please can somebody advise me where I am going wrong, I have an Excel file put together in Excel 2002/2003 using xls.
I have upgraded to Office 2010 and instead of using the original xls version have saved the file as an xlsb binary version purely because the file can be around 30Mb or higher depending how many worksheets are added.

While using the xls file, when I press the "SaveAs" button, the file would SaveAs a specific filename without any warnings in the same folder as the original.

Now I have upgraded, I am having issues where the file appears to save but in reality does not.
I have looked on the web to see that a file format number must be used - 50 and have included this in the code but still nothing happens.
Am I writing something wrong.

Please Login or Register  to view this content.

By pressing "Save" will save the open file as normal.
By pressing "SaveAs" will save the open file with a filename with backup in its title without any warning messages of overwriting etc.

Hope somebody can help.

[Kenneth Hobson]

Have you tried Application.EnableEvents =False before the SaveAs? Set it to True at the end obviously.

[sparx]

Hi Kenneth, thanks for your suggestion, yes I tried your options, I tried almost everything until this.

Excel 2002/2003 would save a copy without any issues and overwrite the old file without warning messages.
Running the same code in Excel 2010 it would crash time and time again, so changed the code to add an If statement.
If the SaveAs button is pressed, it now deletes the backup file, then writes a new backup file, as there is not a backup file to overwrite, the warning message is not needed and does not cause any re-writing issues.

Solved it.

Thank you for your suggestion though.