View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Guido Guido is offline
external usenet poster
 
Posts: 2
Default Saved seems not to work

I wrote a macro that generates an exel file and I save it with save as, but I
don't close it to give the users the possibility to change the file.

The problem I got, is that, when closing the file, Exel doesn't ask to save
the changes, consequence: the users loose all their additions-changes etc,
and they are angry (more than acceptable).

I added a last line : ActiveWorkbook.Saved = False, and checked it: the
status is false, but it does not make a difference.

So, please help.

--
Sometimes frustrated.

Guido