| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create filepath if it's not available
I use the following to save a file to a new folder. How can I have it check
to see if the filepath exists, and if not go ahead and create the path? ActiveWorkbook.SaveAs Filename:= _ "\\Fl-msjf-fs1\Data\Data\RECOVERY\EXLDATA\Loan Recovery MIS\" & MyDate & "\Gross Placement Batch Tracks\Product Breakdown\Quaternary GBT Prod_Breakdown " & MyDate & ".xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filepath | Excel Discussion (Misc queries) | |||
| Filepath | Excel Discussion (Misc queries) | |||
| Using a cell reference in a filepath | Excel Programming | |||
| get filename and filepath | Excel Programming | |||
| Selecting File and FilePath | Excel Programming | |||
Threaded Mode
