Change code to automatically SAVE when workbook is opened

Hello all! I have a button that when clicked runs a macro that saves the workbook in a specific location --

Please Login or Register  to view this content.

Is there a way this macro can run as soon as the workbook opens? I would need the code to run as it is above -- so that it saves the workbook in the same location called out above.

Thanks for your help.

Hello,

Under this workbook, there is an OnOpen Event.

Originally Posted by DGagnon

try adding this to your ThisWorkbook module

Please Login or Register  to view this content.

Thanks for your replies. I pasted your code above and received an error in this line --

ActiveWorkbook.SaveAs FileName:=stFileName

Should that line be altered?

I see where it would work. My problem then becomes: the workbook opens and immediately tries to save to the folder before the file name is added (auto copied from the workbook that called upon it). I'm going to have to play with this some more.

Thank you again! Your help is greatly appreciated.