Multiple Delimiters in Workbook.Open Function

[rahulkumar88]

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