Calling a workbook from VBA and over-riding auto open on target

[steback]

Hi All

I have a (hopefully) quick question as follows:

1) In VBA I need to copy in worksheets from a closed excel file (I can do this part!)
2) The target files that I am copying from have VBA coding that runs on open (a normal auto open macro)
3) I want to stop the auto open code running when I load the target workbook to copy in the worksheets......this is where I am stuck - can it be done?!

Any help appreciated!

TIA

Steve

 

[johnnyL]

Open them as read only.