ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cannot save macro in excel (https://www.excelbanter.com/excel-programming/424766-cannot-save-macro-excel.html)

[email protected]

cannot save macro in excel
 
Hello. I have created s macro in VBA. Once I run the macro I need to save the
file (in the format that it is in after the macro has run) however excel does
not save the file. The only thing that happens is a text box pops up saking
"file did not save" and gives no reason for not saving. I checked and the
file is in the correct format and has an origional name... why does it not
save?

joel

cannot save macro in excel
 
If you are using Excel 2007, then go on worksheet to File - SAVEAs and select
the type of file as .XLSX and then save.

" wrote:

Hello. I have created s macro in VBA. Once I run the macro I need to save the
file (in the format that it is in after the macro has run) however excel does
not save the file. The only thing that happens is a text box pops up saking
"file did not save" and gives no reason for not saving. I checked and the
file is in the correct format and has an origional name... why does it not
save?


curlydave

cannot save macro in excel
 
Could you supply the code?


All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com