File saving error

**Ravana** · 03-10-2015, 09:01 AM

Please Login or Register  to view this content.

In the code when I run it, everything is working fine except when I give file name after prompting where to save, it is prompting "File exists. Overwrite?", though no file exists with such name and also, if I say yes, it says "File Not Found". Silver lining is though error is occuring, file is being saved. Help needed to get rid of the error prompting.

I have to submit that I google and found the bits and pieces of the code which I clubbed to get this code.

**Parth007** · 03-10-2015, 09:11 AM

Can u share the excel file... as ExportToTextFile gives error.. missing function code...

**Ravana** · 03-10-2015, 09:18 AM

I have attached the excel file.

I use the code assign to button "SAVE AS TXT FILE" ON THE SHEET "ECS VAL"

**Parth007** · 03-10-2015, 09:27 AM

Hi Ravana,

Please find the attached file...Run & Check for your conditions

**Ravana** · 03-10-2015, 09:35 AM

@pARTH007....Me Happy...Glad u helped me...Thanks a lot.

What if a file already exists with the name I am giving. Shouldn't it warn me to "Over write?", If yes the proceed other-wise choose another name.

**Parth007** · 03-10-2015, 09:38 AM

Trying to fix this.. but not getting correctly..
Experts please help

File saving error

LinkBack

Thread Tools

Rate This Thread

Display

File saving error

Re: File saving error

Re: File saving error

Re: File saving error

Re: File saving error

Re: File saving error

Thread Information

Users Browsing this Thread

Similar Threads

Error in opening file and saving a file

Error handling - Saving file

Error when saving to file

error saving excel file

Error In Saving Excel File

Bookmarks

Bookmarks

Posting Permissions