Hi,

I can find loads of macros that will seperate worksheets in a workbook to seperate workbooks - trouble is I cant find any that run from a seperate file.

EG: http://stackoverflow.com/questions/9...l-file-chooser
http://www.mrexcel.com/archive/VBA/5788.html

What I want to do is have an excel file called 'runme' so that when a new 'data' excel file (with the worksheets) is placed in a folder, a user can open the 'runme' file, press a button linked to a macro that then seperates the worksheets - this way the macro always exists. The data file keeps changing each month with last months data so I cant put it in there. I cant use the PERSONAL.XLS method as the users may vary and its only purpose is to seperate worksheets for this file.

Ideally if it could extract the new workbooks to a folder location that would be best so the user can always quickly delete the folder before running new data each month

Not very good with VBA - can someone help as to how to make a macro work on another workbook rather than the active one? For simplicity we can call the new data file 'newdata.xls' - working in excel 2003 - any help appreciated

Thanks,

Adam