| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Worksheets
I am trying to save a "worksheet" from the active workbook_A into a new
workbook_B, but I am wanting the user to input a filename to give workbook_B. I'm assuming I have to create a UserForm to grab the input name from the user. Worksheets("from workbook_A").Select Worksheets("LogHistory").SaveAs = "c:\temp\<filename from UserForm" No success. Can anyone prescribe a remedy that is simple? Thank you. D. Parker |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| All worksheets in document are not saving! | Excel Discussion (Misc queries) | |||
| Saving a File of worksheets | New Users to Excel | |||
| saving training worksheets | Excel Discussion (Misc queries) | |||
| Saving Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Saving worksheets | Excel Worksheet Functions | |||
Threaded Mode
