+ Reply to Thread
Results 1 to 2 of 2

Manage Excel files types

  1. #1
    Registered User
    Join Date
    09-04-2008
    Location
    Sydney, Australia
    Posts
    9

    Manage Excel files types

    I have a large number of Excel files being used in Production (over 100,000). I was wondering whether anyone new of a tool that could review all Excel files to determine whether the files have external links within them.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    You can loop through the workbooks, opening each in turn, and check the LinkSources property for each. If it returns Empty, there are no links.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. searching for values through multiple excel files
    By SKooT1027 in forum Excel General
    Replies: 0
    Last Post: 09-15-2008, 11:08 AM
  2. Excel is converting .csv files
    By KRayKeeling in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-21-2008, 07:00 PM
  3. Replies: 1
    Last Post: 03-12-2008, 09:14 AM
  4. Excel files on other PCs
    By JHHT in forum Excel General
    Replies: 1
    Last Post: 03-08-2008, 04:29 PM
  5. Excel Setting - importing files from Trendstar
    By caper91 in forum Excel General
    Replies: 0
    Last Post: 12-21-2007, 10:31 AM

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