I have written a macro that transfers data from one
workbook to other workbooks.I want to use this macro on
older workbooks that dont actually have the module.When i
try to use a toolbar button it opens the workbook that
does have the macro so upsetting the windows that i want
open to transfer the data.Is there a way?.I cant simply
call the workbooks by name because each workbook has a
unique number as a name.