+ Reply to Thread
Results 1 to 3 of 3

IsFileOpen function not found

  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    Pune
    MS-Off Ver
    2010
    Posts
    14

    Question IsFileOpen function not found

    Hi,

    I am trying to check File.xlsx file is open or not by function "IsFileOpen()" ,but it through an error "Sub or Function not Define".
    Can anyone tell me know which reference (DLL) is missing or can/cannot use this function?

    Regards,
    Deepika

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: IsFileOpen function not found

    Hi,

    I don't believe IsFileOpen() is a native function, but can be written thus:

    Please Login or Register  to view this content.
    from https://support.microsoft.com/en-us/kb/291295
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool Re: IsFileOpen function not found


    Hi !

    You can find it in this post or this another one !

    Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

+ 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. indirect function bug found?
    By roj.vinoya in forum Excel General
    Replies: 2
    Last Post: 03-03-2015, 03:35 AM
  2. Why do i get Sub or Function not defined on If IsFileOpen?
    By Pipen88 in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2014, 02:28 PM
  3. macro function not found?
    By okl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2010, 06:47 AM
  4. IsFileOpen function not working correctly
    By rjtools in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2008, 01:42 PM
  5. [SOLVED] YEAR function name not found
    By John Michl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2006, 03:00 PM
  6. Reference Cell if Found in a IF function
    By A Stevens in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-25-2005, 01:30 PM
  7. File or function not found error
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2005, 02:05 PM

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