LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seeing Text File Names when Saving Excel Files jkiser New Users to Excel 4 January 1st 09 01:57 PM
Seeing existing file names when saving jkiser Excel Discussion (Misc queries) 1 December 12th 08 06:27 PM
Look up Values from other file based on combo box's option Jac Excel Discussion (Misc queries) 2 July 1st 07 12:59 PM
Saving file names in a different color MarkT Excel Discussion (Misc queries) 1 December 1st 06 02:24 AM
Saving file names in a different color DougieVan Excel Discussion (Misc queries) 0 November 29th 06 04:28 PM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"