Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfering Information | New Users to Excel | |||
Transfering Info | Excel Discussion (Misc queries) | |||
transfering data | Excel Programming | |||
Need code for transfering cell value to text box. | Excel Programming | |||
Transfering values? | Excel Programming |