Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to set the File Save as File Name from User Form Text Box Names?
Example: These are text Box Names. "Spec TEO_No_1 CLLI_Code_1 CES_No_1 TEO_Appx_No_2 .xls" If possible the save screen comes up with the name below already assigned, but the user can pick the directory. I would like for the file name to look something like this: Spec 2HCC201200 ATLNGACS 403711 00 I have the following code that Joel helped me with but I get a Compile Error: Method or data member not found ' Save Engineering Spec 11 Control Button Private Sub Save_Engineering_Spec_11_Click() (Error Message is Here) Folder = "c:\Tech\" Set bk = ThisWorkbook bk.SaveAs Filename:=Folder & TEO_No_1.Value bk.SaveAs Filename:=Folder & CLLI_Code_1.Value bk.SaveAs Filename:=Folder & CES_No_1.Value bk.SaveAs Filename:=Folder & TEO_Appx_No_2.xls.Value End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seeing Text File Names when Saving Excel Files | New Users to Excel | |||
Seeing existing file names when saving | Excel Discussion (Misc queries) | |||
Look up Values from other file based on combo box's option | Excel Discussion (Misc queries) | |||
Saving file names in a different color | Excel Discussion (Misc queries) | |||
Saving file names in a different color | Excel Discussion (Misc queries) |