PC Review


Reply
Thread Tools Rate Thread

cannot save macro in excel

 
 
robyn_willson@hotmail.com
Guest
Posts: n/a
 
      26th Feb 2009
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?
 
Reply With Quote
 
 
 
 
Joel
Guest
Posts: n/a
 
      26th Feb 2009
If you are using Excel 2007, then go on worksheet to File - SAVEAs and select
the type of file as .XLSX and then save.

"(E-Mail Removed)" 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?

 
Reply With Quote
 
CurlyDave
Guest
Posts: n/a
 
      28th Feb 2009
Could you supply the code?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel macro to open Sharepoint list in excel and save in my folde kay Microsoft Excel Programming 0 24th Jul 2008 09:46 PM
internet connection via excel macro at timed intervels & save data to excel file. Sam Microsoft Excel Programming 3 26th Jul 2007 12:50 AM
internet connection via excel macro at timed intervels & save data to excel file. Sam Microsoft Excel Worksheet Functions 1 22nd Jul 2007 06:08 AM
Macro excel save =?Utf-8?B?bXJiYWxhamU=?= Microsoft Excel Misc 0 12th May 2005 07:02 AM
ASP: Open Excel File with Macro, Allow Macro to run, and then save =?Utf-8?B?ZGVsZ2Fkb3MxMjk=?= Microsoft Excel Programming 0 10th Mar 2005 09:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:34 PM.