| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get link file name in vba
Hi, guys, My excel has a few links to some of the other files. I want to get the directories of all these files to the variants in vba, how can I do that. For example: ActiveWorkbook.ChangeLink Name:= _ "K:\report_wk28_20060714.xls", NewName:= _ "K:\report_wk28_20060714.xls", Type:=xlExcelLinks I want to get a string "a" and a="K:\report_wk28_20060714.xls"  Thanks a lot! Ppyxl -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=562017 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get link file name in vba
Pls Pls Pls help! Thanks! -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=562017 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get link file name in vba
Look at VBA's help for LinkSources.
ppyxl wrote: Hi, guys, My excel has a few links to some of the other files. I want to get the directories of all these files to the variants in vba, how can I do that. For example: ActiveWorkbook.ChangeLink Name:= _ "K:\report_wk28_20060714.xls", NewName:= _ "K:\report_wk28_20060714.xls", Type:=xlExcelLinks I want to get a string "a" and a="K:\report_wk28_20060714.xls" Thanks a lot! Ppyxl -- ppyxl ------------------------------------------------------------------------ ppyxl's Profile: http://www.excelforum.com/member.php...o&userid=36116 View this thread: http://www.excelforum.com/showthread...hreadid=562017 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
| Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
| Excel file link with word file | Excel Worksheet Functions | |||
| xls spool file doesn't automatically link to new xls file | Excel Discussion (Misc queries) | |||
| How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file? | Excel Programming | |||
![ppyxl[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
