| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to check if folder exists
hi does anybody know how i am find out if the folder already exist have a macro which opens a specific folder and then creates a ne folder within. It works how ever everytime I run and if the folde exists it comes up with an error Run-time error 75 : Path/file acces error. which is correct as it cannot create two folders exactly th same. any ideas around this -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=47577 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to check if folder exists
trap the error.
"funkymonkUK" wrote in message ... hi does anybody know how i am find out if the folder already exist I have a macro which opens a specific folder and then creates a new folder within. It works how ever everytime I run and if the folder exists it comes up with an error Run-time error 75 : Path/file access error. which is correct as it cannot create two folders exactly the same. any ideas around this? -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=475775 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to check if folder exists
On error resume next
mkdir "C:\ABC" mkdir "C:\ABC\EFG" On Error goto 0 -- Regards, Tom Ogilvy "funkymonkUK" wrote in message ... hi does anybody know how i am find out if the folder already exist I have a macro which opens a specific folder and then creates a new folder within. It works how ever everytime I run and if the folder exists it comes up with an error Run-time error 75 : Path/file access error. which is correct as it cannot create two folders exactly the same. any ideas around this? -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=475775 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to check if folder exists
thanks that workes. thanks agai -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=47577 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
| Create folder if it does not exists | Excel Programming | |||
| Test if a folder exists, create if it doesn't? | Excel Programming | |||
| Test if a folder exists | Excel Programming | |||
| Checking to see if Folder exists | Excel Programming | |||
![funkymonkUK[_76_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
