Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating folder
i want my program to save in a certain area of our
server, but how do i make it create the final folder? (in case it matters the program is below) Private Sub CommandButton11_Click() If Range("k265") = 1 Then If Range("h251") = "Job #" Then Exit Sub ActiveWorkbook.SaveAs Filename:="\\Cpi-server-1 \estimate\Quotes\EST" & Range("q262") & "000\EST" & Range ("q262") & Range("q263") & "00\" & Range("h251") & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False Else 'For Each w In Application.Workbooks: w.Activate: If Range("q297") = 0 Then MsgBox "This file is not linked.": Exit Sub Else If Range("q292") = 1 Then MsgBox "" ActiveWorkbook.SaveAs Filename:="\\AAA-server-1 \estimate\Quotes\EST" & Range("q262") & "000\EST" & Range ("q262") & Range("q263") & "00\" & Range("q261") & "\" & Range("h251") & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False Else ActiveWorkbook.SaveAs Filename:="\\AAA-server-1 \estimate\Quotes\EST" & Range("q262") & "000\EST" & Range ("q262") & Range("q263") & "00\" & Range("h251") & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False End If End If 'Next w End If |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating folder
Lawson wrote:
i want my program to save in a certain area of our server, but how do i make it create the final folder? See MkDir in VBA help. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a favorite folder in Excel | Excel Discussion (Misc queries) | |||
Creating a folder on SaveAs | Excel Discussion (Misc queries) | |||
Creating new folder for template charts | Charts and Charting in Excel | |||
Creating a folder | Excel Discussion (Misc queries) | |||
Creating a new folder that does not already exsit. | Excel Discussion (Misc queries) |