Open text file delimited semicolon with VBA

[pezalmendra]

Hi,

Searching through the web I found some codes to open directly text files with a VBA code in Excel. The thing is that they just open the file and does not separate the text into columns, so I then have to do it manually...

It's a semicolon delimited file. Maybe someone knows or have a code to open this kind of files...
What I have also noticed is that you have to enter manually the directory where the file is saved.

Many thanks like always!!

Regards,


pezal

[pezalmendra]

Hello again!

Finally manage to find a way for doing what I was looking for:

Please Login or Register  to view this content.

There is only one problem I am finding and maybe someone can help me on this, this code only works for "space delimited" files and not for "semicolon delimited" that is what Im looking for...

Any help would be much appreciated.

Thanks and regards!