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

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