rahulkumar88
New Member
- Joined
- Apr 9, 2011
- Messages
- 16
Hi,
I have a folder that contains numerous text files and I need to import these into excel. I'm using the Workbook.Open function to import the text files however the text files use different delimiters and I wanted to know how to include multiple delimiters in the workbook.open function. I'm unable to mention more than one delimiter there.
I would appreciate any help that you could provide.
Thanks in advance.
Rahul
I have a folder that contains numerous text files and I need to import these into excel. I'm using the Workbook.Open function to import the text files however the text files use different delimiters and I wanted to know how to include multiple delimiters in the workbook.open function. I'm unable to mention more than one delimiter there.
I would appreciate any help that you could provide.
Thanks in advance.
Rahul