Changing File Names and Linking Cells between workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have one master Workbook where I am bringing worksheets in from other
Workbooks. Some of the cells are linked with Name, Date, and Project Number
which resides in the master workbook and must transfer when the worksheet is
brought in.. My Problem is: My master workbook can change names which
affects the linked data file name in the worksheets I am bringing in. The
code in the linked cell reads “ ='Z:\Project Forms XLS\[My Project
Template.xls]Menu'!$E$5 “ but my file name can change. Can I use a variable
or something in my linked data to accommodate changing master worksheet file
names?
 
James:

try it,


ActiveWorkbook.ChangeLink "Z:\Project Forms XLS\My Project Template.xls", _
"Z:\Project Forms XLS\My Project Template-1.xls", xlExcelLinks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy and paste data only to a new file 1
Changing name of worksheet based on data in cell of another worksheet 14
Copying cells and formula from closed workbook to all sheets in open workbook 0
How to reference a cell from anther workbook without opening it 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy Changes in one workbook to another identical Master Workbook 6
split worksheet after empty row into separate workbooks 3
Macro to copy specific data from master workbook to another workbook 13

Back
Top