Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Background: Opening a tab delimited file, generated by netsh, with Excel to
format the data. Formatting includes creating new worksheets. Here's the short code in vbscript: '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''' Set objExcel = WScript.CreateObject("Excel.Application") 'Opening existing Workbook Set objExcelWorkbook = objExcel.Workbooks.Open(filename) 'Adding worksheet to opened, existing workbook objExcel.Worksheets.Add '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''' What happens with the above code is the data in the existing worksheet gets overwritten, but the name of the worksheet is retained. Value add: Any good reference on vbscriipt, Excel specific objects & methods would be appreciated. VBA references tend toward VB and not VBScript, which means you waste a lot of time trying to figure out what objects and methods are available and how they should be formatted. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If then formulas | Excel Worksheet Functions | |||
How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
is it possible to apply template to a existing worksheet | Excel Worksheet Functions | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
Creating new worksheet from existing | Excel Discussion (Misc queries) |