View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Lost Lost is offline
external usenet poster
 
Posts: 55
Default A workbook of macros which runs on external workbooks.

Joel,

Thanks for your help and sorry about the confusion.

No, right now, the macro tests the current workbook (good), but adds a sheet
to it (bad).

I was wanting to run the macro from my Personal.xls and if any sheets get
added, they would add to Personal.xls rather than the file being tested. (I
don't want to mess with the tested sheets if I don't have to.)

I thought that the GetFileName thing (which worked for another macro) would
work for that, but I couldn't get GetFileName to work with the macro you
designed. It's in that top section where you select the workbook but I don't
know enough to get it to work.

Anyway, I appreciate the help!

VR/

Lost