I'm sure this has been beat to death, but I've spent the past 2 days looking for a thread or something guiding me in the right direction.

What I'm trying to do is run a macro when 'main.xls' is opened.

The macro is to then open 2 more workbooks and then hide both of those newly opened workbooks.

The workbooks to open are: customerleads.xls and followup.xls.

All three files(main.xls , customerleads.xls , followup.xls) are found in folder c:\excel

To Review:
1.) The macro is to run when main.xls is opened
2.) The macro then opens 2 workbooks named: customerleads.xls and followup.xls
3.) The macro is to then hide customerleads.xls and followup.xls

I'm so frustrated with this I'm about to pull my hair out!

Thanks for you help folks,