Need a VBA code to run when a workbook is opened

**amberella** · 01-29-2014, 03:31 PM

Hello, first time posting here. I have an Access query that overwrites an excel file everytime it is exported. I am wondering if I can have some VBA code in another workbook that when that Excel file, with the same name every time, is opened, the code will automatically run to open another workbook?

Thanks.

**judgeh59** · 01-29-2014, 03:36 PM

YOu can set the name of the sub to Auto_Open and when the XL file opens it will automatically start that code....inside there you can do anything you want....the bad part --- when you need to troubleshoot the XL file auto-opens you have to hit Ctrl-Break to stop the code from running so you can fix/update/change your code....HTH

**amberella** · 01-29-2014, 04:08 PM

I tried that, but when the file is overwritten, the code is lost. My thought is to store the code in a separate workbook so that when workbook A is opened (the overwritten file) workbook B will also open. But I'm not sure how to write that code or if it's even possible.

Thanks.

**MarkWh** · 02-28-2014, 07:03 AM

I tried doing this by storing the Auto_Open macro in PERSONAL.XLSB, but :-(
When I click on any existing file, the macro runs as soon as Excel opens but Before the worksheet opens ... which means that I get an error