ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can DIR detect if a Folder exists? (https://www.excelbanter.com/excel-programming/429851-can-dir-detect-if-folder-exists.html)

kirkm[_8_]

Can DIR detect if a Folder exists?
 

I find no difference using DIR between a non existant Folder Vs an
empty Folder.

Thanks - Kirk

Doug Glancy

Can DIR detect if a Folder exists?
 
Kirk,

You need to specify "vbDirectory" as the 2nd argument.

hth,

Doug

"kirkm" wrote in message ...

I find no difference using DIR between a non existant Folder Vs an
empty Folder.

Thanks - Kirk

__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4153 (20090613) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




__________ Information from ESET NOD32 Antivirus, version of virus signature database 4153 (20090613) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




kirkm[_8_]

Can DIR detect if a Folder exists?
 
On Sun, 14 Jun 2009 21:46:59 -0700, "Doug Glancy"
wrote:

Kirk,

You need to specify "vbDirectory" as the 2nd argument.


Thanks Doug. Worked a treat !

Cheers - Kirk


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com