View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les[_4_] Les[_4_] is offline
external usenet poster
 
Posts: 21
Default After SaveAs events - are there any?

Hi

The very last thing I need for my project (that is until I find
other needs:-)

I have set up a means of keeping backups based on various
criteria - all this works well.

However, I now need to find the current ActiveBook.FullName on
exit from the SaveAs dialog as the name has changed to match the
Saved As filename. I can't seem to find any event that fires after
the SaveAs. I can't use the BeforeSave as the name hasn't changed
at that time, and obviously I can't call any sub from within the
BeforeSave sub as the Save hasn't happened yet.

Any ideas or solutions?

regards,
--
Les Hay, Livingston. Scotland