Hi All
I have a number of workbooks I wish to extract data from, the extract
routine is in another control workbook that opens each in sequence copies
the data into the control book. My problem is that each of the workbooks I
am opening contains a workbook_open event that loads a userform. (Excel 97).
How do I either prevent the workbook open event happening or close the
userform in the newly opened workbook so that I can copy data and then close
it?


--
Cheers
Nigel