| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning Name to new workbook
Want to assign a name to a worksheet based on user input.
DataFileName = Application.GetOpenFilename(filefilter:="Text or ASC Files, *.txt; *.asc", Title:="Select the Data File") 'Create A New WorkBook With One Worksheet Workbooks.Add template:=xlWorksheet Want the workbook name to be the same name as that opened by DataFileName and not "Sheet1". Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assigning Name to new workbook
Then you need to save it with that filename, the filename only gets assigned
on a save. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dan" wrote in message ... Want to assign a name to a worksheet based on user input. DataFileName = Application.GetOpenFilename(filefilter:="Text or ASC Files, *.txt; *.asc", Title:="Select the Data File") 'Create A New WorkBook With One Worksheet Workbooks.Add template:=xlWorksheet Want the workbook name to be the same name as that opened by DataFileName and not "Sheet1". Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assigning Name to new workbook
Is there a way to prefill in the "File Name:" in the Save As window?
"Bob Phillips" wrote: Then you need to save it with that filename, the filename only gets assigned on a save. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dan" wrote in message ... Want to assign a name to a worksheet based on user input. DataFileName = Application.GetOpenFilename(filefilter:="Text or ASC Files, *.txt; *.asc", Title:="Select the Data File") 'Create A New WorkBook With One Worksheet Workbooks.Add template:=xlWorksheet Want the workbook name to be the same name as that opened by DataFileName and not "Sheet1". Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assigning Name to new workbook
Why would you use the SaveAs window? you have the filename so just save it
with that name. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dan" wrote in message ... Is there a way to prefill in the "File Name:" in the Save As window? "Bob Phillips" wrote: Then you need to save it with that filename, the filename only gets assigned on a save. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dan" wrote in message ... Want to assign a name to a worksheet based on user input. DataFileName = Application.GetOpenFilename(filefilter:="Text or ASC Files, *.txt; *.asc", Title:="Select the Data File") 'Create A New WorkBook With One Worksheet Workbooks.Add template:=xlWorksheet Want the workbook name to be the same name as that opened by DataFileName and not "Sheet1". Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
| Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
| keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
| Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Linear Mode
