View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Saving File with names from Text Box's

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