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
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
Hi,
I don't believe IsFileOpen() is a native function, but can be written thus:
from https://support.microsoft.com/en-us/kb/291295Please Login or Register to view this content.
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".
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 » !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks