| 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 |
| 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 | |||
Threaded Mode
