Results 1 to 2 of 2

Read Excel Connection File Source Path in VB

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2018
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    4

    Read Excel Connection File Source Path in VB

    Hi.
    New to forum.
    I have a number of Queries (3) consisting of linked Worksheets.
    I am trying to read their source file paths in VB ... as I have another routine that each time the User refreshes the data and uses the VB code to manipulates it .... it copies the source file and renames it with a Date Time stamp.

    I can see all the Connections that are there by use of
    Dim conn As WorkbookConnection
    
    For Each conn In ActiveWorkbook.Connections
      Debug.Print conn.Name
    Next conn
    I cant seem to find a way to read the "Connection" file source. Read a lot of other posts but I am sure it will be blindingly obvious when explained. Thanks in advance.
    Last edited by alansidman; 09-23-2018 at 10:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MS Access ADODB Connection String - Invalid File Path, Does not Exist
    By ironfelix717 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2018, 08:01 AM
  2. Expected table is not in the expected format - ADODB Connection to Read Only Excel file
    By Roshan10043 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2018, 10:54 AM
  3. ADODB connection - Changing connection path via fileDialog
    By cajand in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2015, 08:06 AM
  4. Auto save Excel ODBC Connection to data source without opening file
    By newbie4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2015, 01:37 PM
  5. Replies: 0
    Last Post: 05-08-2014, 11:42 AM
  6. Update path to an XML file connection
    By jaume in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 02:35 PM
  7. Automated Import of .csv File into Excel Using Variable as Connection Path?
    By dsfcom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2008, 10:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1