Saving .CSV file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top