Thread: How to get link file name in vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ppyxl[_13_] ppyxl[_13_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote