Using beforesave event to change filename

A

Alex

I've written a code to control how the file name is saved in order to keep a standard name pattern, using the Beforesave event to trap the saving routine, processing the filename text string and then finishing it with the .Saveas method.

Such code has worked fine in Excel, but when used in MS Project it is leading to a infinite loop. The cause I found to be the missing .Enableevents propriety that was used in Excel, but I couldn't find it in MSP nor an equivalent.

Please, if anyone has any suggestion on how to break the loop, is more than welcome.

Regards,
Alex
 

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

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Need help with BeforeSave event 4
Error when using the BeforeSave event 2
BeforeSave Problems 2
BeforeSave Event 5
Infinite loop cancelling BeforeSave 10
workbook beforesave event 4
Event - before save, after filename 4

Top