[RESOLVED] EXCEL VBA, Save AS VS Before Save Event

[billhuard]

Hi guys,

I'm having a little problem here.

I have a master excel file(file 1) that open another file(file 2).
File 2 have an before save procedure.
File 1 modify file 2 and try to save it.

But File 1 cannot save file 2. I' getting an error, file in use witch is true because file 2 has before save proc that is call when file 1 try to save file 2.

How can I overcome this???

Thanks

[DKenny]

Bill
If you disable Events before saving, the Before Save proc will not be called, just make sure you re-enable afterwards.

Application.EnableEvents = False
File2.Save
Application.EnableEvents = True

[billhuard]

right on.


Thanks again Declan