LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfering Information Chrissie New Users to Excel 1 October 31st 08 05:56 AM
Transfering Info Junderwood57 Excel Discussion (Misc queries) 2 August 15th 07 01:54 PM
transfering data pisanichris[_2_] Excel Programming 1 October 15th 05 09:18 PM
Need code for transfering cell value to text box. Matt[_31_] Excel Programming 5 April 26th 05 11:02 PM
Transfering values? Megan[_2_] Excel Programming 3 April 9th 04 10:25 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"