| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open text files as a worksheet
Please help a VBA beginner. Thanks a lot! 1. How to open a text file as a worksheet in a workbook that's alread created? 2. How to address a worksheet by name instead of by number? Thanks ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open text files as a worksheet
I do not beleive you can open a text file as a worksheet in an existin workbook. I beleive you would need to inport to an existing sheet To address workbooks/worksheets by name use workbooks("Name") worksheets("name" ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2003 sp3 changes how text .xls files open | Excel Discussion (Misc queries) | |||
| Excel files don't open until a click on blank worksheet | Excel Discussion (Misc queries) | |||
| Open several text files using a macro | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| How to open up 50 text files in 1 worksheet in fewest moves? | Excel Worksheet Functions | |||
Linear Mode
