open text files as a worksheet

C

clui

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
 
M

mudraker

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"
 
Top