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"
:confused:

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

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

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"
:confused:

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