Hi All,
I need to read in csv file.
If I open new Excel file and then open csv file then it is opened in correct way. I mean all data is spread into right columns.
I have recorded the macro and so figured out that I need Workbooks.Open "C:\vb script\Test.csv" command.
Unfortunately If I use this command from my test macro (which contains only this command) then the file is being read in but into one column (with ";" as separator)
I have tried to use Workbooks.Open "C:\vb script\Test.csv", , , , , , , , ";" (also instead of ";" I tried vbTab)
But it is not working.
Any suggestions?
Regards,
Tym