+ Reply to Thread
Results 1 to 8 of 8

Get a list of all open files in non-Office applications

  1. 12-14-2019, 01:10 PM #1
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Get a list of all open files in non-Office applications

    Hi guys,

    How to get the list of all open file (currently open) in excel using VBA?
    Open file can be any file, it can be image, dox, pdf, xlsx, ai etc.
    It has been posted here--https://www.mrexcel.com/board/thread.../#post-5388367

    I have got feedback , which give me the open excel file details, here below the code.
    https://www.mrexcel.com/board/thread.../#post-5387900

    But it don't give me the others file type details.
    Like I have one PDF, JPG & DOC opened currently, but it don't give me the details of those file.
    Is it possible to get the details of those file in excel cell or not?
    Last edited by 6StringJazzer; 12-15-2019 at 11:46 AM. Reason: Updated title to more clearly describe the problem
    Reply With QuoteRegister To Reply
  2. 12-14-2019, 02:26 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,693

    Re: Get the list of all open file in vba

    Quote Originally Posted by mehidy1437 View Post
    Like I have one PDF, JPG & DOC opened currently, but it don't give me the details of those file.
    Are these files open in Excel, or some other applications?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 12-14-2019, 10:05 PM #3
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41
    Quote Originally Posted by 6StringJazzer View Post
    Are these files open in Excel, or some other applications?
    Those file open in their own application, not in excel.
    Reply With QuoteRegister To Reply
  4. 12-15-2019, 09:01 AM #4
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question

    Hi !

    So the question is : why using Excel for a non Excel concern ?‼
    Reply With QuoteRegister To Reply
  5. 12-15-2019, 12:34 PM #5
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41
    Quote Originally Posted by Marc L View Post
    Hi !

    So the question is : why using Excel for a non Excel concern ?‼
    Then how can I get it?
    is there any other way?
    Reply With QuoteRegister To Reply
  6. 12-15-2019, 04:19 PM #6
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Get a list of all open files in non-Office applications

    If we can get the details of all files type from a folder in excel, then why we can't get all types of open files details in excel?
    Hope some expert will have a look on this issue & will comments.
    Reply With QuoteRegister To Reply
  7. 12-15-2019, 05:33 PM #7
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,693

    Re: Get a list of all open files in non-Office applications

    Quote Originally Posted by mehidy1437 View Post
    If we can get the details of all files type from a folder in excel, then why we can't get all types of open files details in excel?
    Because looking at files in the Windows file system and finding out which files every running process has open are two completely separate things.
    Reply With QuoteRegister To Reply
  8. 12-15-2019, 05:34 PM #8
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    You are confusing files on a disk and files currently used in the OS ! First See on a system forum …
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to open a list of spreadsheet and save them under file extension xlsx file
    By gdclyde in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2017, 07:16 PM
  2. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  3. Create macro to open selectable list then open file
    By mattmurdock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2012, 07:10 PM
  4. VBA - Open File from List in Worksheet
    By bentleybob in forum Excel General
    Replies: 0
    Last Post: 09-22-2011, 03:11 PM
  5. list from many workbooks and file open
    By wegkruip in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2010, 08:24 AM
  6. Open a file from list
    By rbeck in forum Excel General
    Replies: 0
    Last Post: 07-17-2008, 01:35 PM
  7. File Open List in floating box
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-28-2008, 10:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1