Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing Text in a Cell Reference
Collective guruosity --
I've built two workbooks, one ('User Data.xls') that pulls a lot of info from the other ('Reference Data.xls'). I want to distribute this set to other company employees. The problem is this: When I send them to the new user's computer, 'User Data' still looks to the workbook on MY computer, rather than the new one on the user's box. I've instructed the users that I want these two workbooks to be in the same folder. I already have some code that starts up as the workbook opens. I would think I could add some more that wipes out the references to my computer, and replaces each with just a "\", to look in the same folder on the user's computer. However, I'd like to make the 'find-and-replace' language generic so that it can't go wrong. All the cells affected are on a single page in 'User Data', named "Chart Preparation". Thanx in advance for any help you can give me. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing Text in a Cell Reference
Hi,
Manually, to modify the path/source for external links, you would go in Edit Links. The vba equivalent is: thisworkbook.ChangeLink currentNam, newName, type see the online help on this method. -- Regards, Sébastien <http://www.ondemandanalysis.com "pdberger" wrote: Collective guruosity -- I've built two workbooks, one ('User Data.xls') that pulls a lot of info from the other ('Reference Data.xls'). I want to distribute this set to other company employees. The problem is this: When I send them to the new user's computer, 'User Data' still looks to the workbook on MY computer, rather than the new one on the user's box. I've instructed the users that I want these two workbooks to be in the same folder. I already have some code that starts up as the workbook opens. I would think I could add some more that wipes out the references to my computer, and replaces each with just a "\", to look in the same folder on the user's computer. However, I'd like to make the 'find-and-replace' language generic so that it can't go wrong. All the cells affected are on a single page in 'User Data', named "Chart Preparation". Thanx in advance for any help you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing Text in a cell with blanks | Excel Discussion (Misc queries) | |||
Replacing cell reference on multiple sheets in one go.... | Excel Worksheet Functions | |||
Replacing a Table-array with a cell reference in vlookup | Excel Worksheet Functions | |||
replacing text in a cell | Excel Discussion (Misc queries) | |||
Replacing hard code with reference to a cell value | Excel Programming |