open text files as a worksheet

  • Thread starter Thread starter clui
  • Start date Start date
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
 
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"
 
Back
Top