Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code...
Dim fso As Object, PathName as string Set fso = CreateObject("Scripting.FileSystemObject") PathName = c:\blahblah If fso.FileExists(PathName) Then Do this and that This usally works a treat except that when the pathname specified has a case change. For example If c:\Hello.doc exists and I set PathName = c:\hello.doc then the fso.FileExists function returns false. Can anyone think of a workaround for this? Thanks in advance for any answers Nick Shinkins |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fussy check of cell contents | Excel Discussion (Misc queries) | |||
FileExists Example: | Excel Worksheet Functions | |||
Excel FileExists macro problem.... | Excel Programming |