How to open folder after checking folder not existed?

[london7871]

The VBA below can open folder "Scan":

Please Login or Register  to view this content.

How to advise the VBA so that:
1. If the folder "Scan" is opened, VBA will not open the "Scan" again.
2. The folder opens at the left top corner of the screen.

[JieJenn]

If you use the FileSystemObject API, there is a check folder exists (also file exists) method that does what you are looking for.

https://docs.microsoft.com/en-us/off...mobject-object

Here's a simple VBA code to open a folder if exists

Please Login or Register  to view this content.

[london7871]

Hi JieJenn,

Still not work. The folder Scan is opened even it has already been opened. (i.e. the folder is opened twice).

[JieJenn]

Do you mean to check if a folder explorer is already opened? If that's what you are asking for, then I don't think VBA can do that, at least not an easy task. Even using Java, C#, or Python, checking if a folder explorer is current opened is not an easy task. Sorry to give you the bad news.

[london7871]

Hi JieJenn,

How about firstly close the folder Scan by VBA?

(if there is no currently opened folder Scan then error resume next in VBA, i.e. using your VBA to open folder Scan)

[JieJenn]

Anything related to Folder Explorer window has to use the Windows System Object API, which VBA is not designed to do. But if you are really desperate, then this StackOverflow post might help. https://stackoverflow.com/questions/...e-open-file-ex

[london7871]

Thanks JieJenn for suggestion.

[Leith Ross]

Hello london7871,

Here is a VBA macro to check if the folder is open....

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

[london7871]

Hi Leith Ross,

How to revise your VBA so that
if the folder is open, there is a message "The folder is opened".
if the folder is not open, there is a message "Please open folder".

[Leith Ross]

Hello london7871,

Here is the updated code.

Macro Code

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

[london7871]

Hi Leith Ross,

I tried to modify your VBA to check whether folder "Scan" is opened (with path "C:\Users\DK-01\Desktop\Scan"),
the VBA shows "Folder is Open" if folder "Scan" is currently opened; but cannot show "Please Open Folder" if folder "Scan" is not currently opened.
Please advise.

Please Login or Register  to view this content.