Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mornin' all!
I've got the following code: Dim WebName As String, SaveFolder As String ActiveDocument.Refresh SaveFolder = "\\web1a\PIBReports\BCA\" & WebName & "\" WebName = ReplaceChars(ActiveDocument.Name, " ", "_") CreatePDF SaveFolder, WebName & ".pdf" CreatePDF SaveFolder, WebName & "_" & ReplaceChars(Left (Now, 10), "/", "-") & ".pdf" What I want, is that if the SaveFolder path doesn't exist, for the script to create all the folders that don't exist. The problem is, I don't know how! Please help! Cheers, Foss |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hiding folders | Excel Discussion (Misc queries) | |||
Help with Creating folders on Save | Excel Discussion (Misc queries) | |||
Creating folders and subfolders from excel file list | Excel Discussion (Misc queries) | |||
Read only folders | Excel Discussion (Misc queries) | |||
Creating Folders from Excel Using OLE Automation | Excel Programming |