| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Current Link Value
I have a "Core" workbook which several workbooks can use. Right now I have
to physically open the Core workbook and point it to the whichever workbook it should be looking at now. How can I determine what is the Core workbook currently linked to using VBA? The ActiveWorkbook.ChangeLink takes as its first argument the name of the workbook to which it is currently linked.which I have to replace. The below is from a recorded macro. My hangup is getting the name of the existing workbook for that first argument. ActiveWorkbook.ChangeLink Name:="Jamie11032005XXX.xls", NewName:= _ "PremiumFinancingJamie.xls", Type:=xlExcelLinks .. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link cell in excel to current date | Excel Discussion (Misc queries) | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| Cells to link to "current workbook" | Excel Discussion (Misc queries) | |||
| changing current directory to that of the current open file | Excel Programming | |||
![Dkline[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
