| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find out if its a folder or file
hi guys i need help a little help
myfile contains a folder path or a file i need a way to determine which one it is i tried the instr below but found that files with a "." in missed my loop totally so this doesnot suit my needs is this possible to do? myFile = Dir(myPath, vbDirectory) Do While myFile < "" 'will start LOOP until all files in folder If InStr(myFile, ".") 0 Then |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find latest file in folder & Open | Excel Programming | |||
| VBA can't find file as it moves from folder to folder | Excel Programming | |||
| Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
| Find New File/Folder | Excel Programming | |||
| Find Folder Path + file Name Length and Insert into Spreadsheet | Excel Programming | |||
Threaded Mode
