| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if file exists...
I use the following to save a file to folder. How can I have it check
to see if the filepath exists and it exits then msgbox indicated that file is there and exit sub routine, and if not exists, go ahead and create the path? ActiveWorkbook.SaveAs Filename:="\\my path directory\" & NewFileName & ".xls" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if a File Exists | Excel Programming | |||
| Check if file exists | Excel Discussion (Misc queries) | |||
| Loadpicture - check if file exists | Excel Programming | |||
| How do I check if a sheetname exists in a file? | Excel Programming | |||
| check if file exists | Excel Programming | |||
Threaded Mode
