Computer Forums - View Single Post - Excel VBA OpenText prevent from interpreting data

Roger Tinembart · 04-20-2009, 10:07 AM

> you could prolly access the filesystem and access the file directly without excel.
> you should be able to run vbscript code in a vba editor

Thank you for the reply. I know this is possible and we tried to access the data earlier (a few years ago) through the file system and split it up 'manually' in VBA, but this was very slow compared to opening the file with OpenText and let Excel do the job. So this is unfortunately not an option for me.

Thanks anyway!

04-20-2009, 10:07 AM	#3 (permalink)
Roger Tinembart Newb Techie Join Date: Apr 2009 Posts: 3	Re: Excel VBA OpenText prevent from interpreting data > you could prolly access the filesystem and access the file directly without excel. > you should be able to run vbscript code in a vba editor Thank you for the reply. I know this is possible and we tried to access the data earlier (a few years ago) through the file system and split it up 'manually' in VBA, but this was very slow compared to opening the file with OpenText and let Excel do the job. So this is unfortunately not an option for me. Thanks anyway!