Saving .CSV file

S

Stefi

Hi all,
I have a .CSV file what I process with a VB macro. I save it in the same
format with ActiveWorkbook.Save, the file is saved in order, but the
ThisWorkbook.Saved property remains False and when quitting, I get the
question "Do you want to save the file?" It does the same even if I
explicitely set ThisWorkbook.Saved = True.
Is this a bug? If so, can I do anything in order to avoid bothering users
with unwanted questions?
Stefi
 
N

Nick Hodge

Try

Application.DisplayAlerts=False

I suspect setting you are trying doesn't work on csv

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a macro only work on certain files 2
Trying to create custom labels from an csv file + Need items numerically counted out 0
Change a great number of words in word files, with a macro as short as possible. 5
Addin not allowing thisworkbook.save in before save event 3
Excel CSV Files; Creating Of 3
New computer, how do i move outlook 365 ENTIRELY? 0
Save to CSV macro crashes Excel 2003 3
How To Compare Two Csv Files Mainly Two Columns Containing Time 0

Top