Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for Links to Excel workbooks
Does anyone know where the find the code (for the links)
for linked workbooks? Any help anyone can give me will be greatly appreciated. Sandy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for Links to Excel workbooks
aLinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsEmpty(aLinks) Then For i = 1 To UBound(aLinks) MsgBox "Link " & i & ":" & Chr(13) & aLinks(i) Next i End IfMight be what you mean.If you mean a URL to Bill Manville's findlink utility:http://www.bmsltd.co.uk/MVP/Default.htmRegards,Tom Ogilvy"Sandy" wrote in message ... Does anyone know where the find the code (for the links) for linked workbooks? Any help anyone can give me will be greatly appreciated. Sandy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code for Links to Excel workbooks
Thanks for your response.
The specific problem I'm having is when documents are emailed, the links are broken via changing them to drive C instead of the G it's supposed to be. I am looking for a way to programmatically refer to the links so I can change it in code to G. I assume I'll have to be able to find all of the links to do it. Could you be as specific as possible when you reply? I'm rather dense in this area. Thank you so much. Sandy -----Original Message----- aLinks = ActiveWorkbook.LinkSources(xlExcelLinks) If Not IsEmpty(aLinks) Then For i = 1 To UBound(aLinks) MsgBox "Link " & i & ":" & Chr(13) & aLinks(i) Next i End IfMight be what you mean.If you mean a URL to Bill Manville's findlink utility:http://www.bmsltd.co.uk/MVP/Default.htmRegards,Tom Ogilvy"Sandy" wrote in message ... Does anyone know where the find the code (for the links) for linked workbooks? Any help anyone can give me will be greatly appreciated. Sandy . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
Links between workbooks in excel 2007 | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Very advanced links through excel to several workbooks | Excel Discussion (Misc queries) | |||
In Excel how do I put variables in links to other workbooks? | Excel Worksheet Functions |