Open a Text File Using Open Method (Excel.Application) With A Space & Tab Delimiter
Posted on 2004-08-04
I need to open a text file in excel using the open method.
I need to know how to use the delimiter within the open method.
The delimiter required is a space and tab.
Can you please help.....Urgently.
This is what I have so far.
Set appExcel = CreateObject("excel.application")
Set objWorkbook = appExcel.Workbooks.Open(FileName, delimiter)
What do I do here?