Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't know what it is, I have tried multiple variations of this code and
still cannot get it to function. Sub SaveAndClose1() Path = "C:\Forms\F-50" If Dir(Path, vbDirectory) = vbNullString Then MkDir "C:\Forms\F-50" End If ActiveWorkbook.SaveAs Filename:="C:\Forms\F-50\" & Range("C6").Value & Format(Date, "ddmmmyyyy") & ".xls" 'ActiveWorkbook.Close End Sub Attempting to to have a button that upon clicking will save the workbook to C:\Forms\F-50. No computer that this will be used on will have this folders. So they need to be created but if they have already done so, i want it just to save there. Like I said I've used a lot of different variations and still no go. Please Advise. Your lovable stressed out intern. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i change my default working folder to a networked folder? | Excel Discussion (Misc queries) | |||
Creating a List of the files in a folder in excel | Excel Discussion (Misc queries) | |||
How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
creating an XLS file from " files" data in a Folder | Excel Discussion (Misc queries) |