View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale[_2_] michael.beckinsale[_2_] is offline
external usenet poster
 
Posts: 4
Default inset vba module using vba

Hi All,

Is it possible to insert a VBA module (which has been exported to say
My Documents) into an existing workbook (say myBook1)and then run the
macro in myBook1. I would like to control the operation from a
"Control" workbook so that l can select the source & target multiple
times as l need to add this VBA module to over 50 existing workbooks.

Any idea's / example code greatly appreciated

Regards

Michael beckinsale.