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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Foss
In its simplest form: Sub test() On Error Resume Next MkDir ("C:\Temp\Automade") End Sub If the folder exists already, it errs, which the On Error statement takes care of. But it needs C:\Temp to exist, it can do only one level. -- HTH. Best wishes Harald Followup to newsgroup only please "Foss" skrev i melding ... 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks very much Harald, that'll do nicely!
-----Original Message----- Hi Foss In its simplest form: Sub test() On Error Resume Next MkDir ("C:\Temp\Automade") End Sub If the folder exists already, it errs, which the On Error statement takes care of. But it needs C:\Temp to exist, it can do only one level. -- HTH. Best wishes Harald Followup to newsgroup only please "Foss" skrev i melding ... 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 . |
Reply |
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 |