How to get link file name in vba

P

ppyxl

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
 
D

Dave Peterson

Look at VBA's help for LinkSources.


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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ChangeLink problem 14
File name being changed 2
Word VBA - Want to test if Full Name is NOT Present in document 0
ActiveWorkbook.ChangeLink 9
How to Select A Cell in VBA with a Variable Row Number? 3
Macro To Avoid Link Update of Open Files 3
How to Select A Cell in VBA with a Variable Row Number? 0
Modify a excel link 2

Top