Learn how to a build a cloud-first strategyRegister Now


is possible to DETECT the linked files (or path) inside an excel spreadsheet? in VB6.0

Posted on 2004-11-12
Medium Priority
Last Modified: 2010-05-02
i have several linked excel files, lot of users have it, but i need to know the exact path for a linked file in the spreasheet with VB 6.0.
Question by:matthews_30
1 Comment

Accepted Solution

craigewens earned 300 total points
ID: 12568333
Here is a little macro which might help you.
It determines how many linked objects there are and loops through them finding the source location, then printing them to the sheet in column 10.

It's just an example for you to read though and adapt to your own requirements.

Sub PrintObjectSource()
    If ActiveSheet.Shapes.Count Then
        For i = 1 To ActiveSheet.Shapes.Count
            temp = Right(Selection.SourceName, Len(Selection.SourceName) - InStr(1, Selection.SourceName, "|"))
            ActiveSheet.Cells(i, 10).Value = Left(temp, Len(temp) - 2)
        Next i
    End If
End Sub


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month20 days, 15 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question