Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi Guys, I got this awhile back, and VBA not being my strongest area I
was just wondering if it could be changed? I need to change instead of using "Client Name.xls" I need the text in cell "B13" to be used which would be the clients name. Any help would be great Thanks Sub SaveOneFile() Dim fn As Variant fn = Application.GetSaveAsFilename("Client Name.xls", _ "Quote Form,*.xls", 1, "Select your folder and filename") If TypeName(fn) = "Boolean" Then Exit Sub ActiveWorkbook.SaveAs fn End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change case...help please | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) |