View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C_Ascheman[_2_] C_Ascheman[_2_] is offline
external usenet poster
 
Posts: 7
Default Help transfering code.

On my desktop I have a master excel file. It contains code in ThisWorkbook,
SHeet1, Sheet2, Sheet3, Sheet4, Sheet5, and Sheet6. In a folder called excel
on the server (F:\excel) are 6 more simular excel files named Test1 through
Test6. The code contained within those files are almost exactly like the
master except 1 line. For months now I have been trying to figure out a way
to transfer all the code from the master file (code from all sheets and
ThisWorkbook) to each of the files in the excel folder.
In other words transfering the code from Thisworkbook in the master record
on my desktop to the ThisWorkbook of every file in the excel folder on the
server. Not just ThisWorkbook though. I need it to do this for every sheet
from the master file to every file in the excel folder, but only if I push a
button I setup in the master file to call the code needed.
As I have said I have been working on this for several months now, and I am
at a complete loss as to what I need to do to complete this. Please help as I
am now starting to realize this may be a bit out of my skill range.

Thanks
C_Ascheman