Excel CSV importing

  • Thread starter Thread starter Vitor Hugo
  • Start date Start date
V

Vitor Hugo

I created a script that download a CSV file (with
delimiting character that Excel recognizes) from a web
site.
One computer with EXCEL 2000 (SR1) can import that CSV
file just clicking on it.
In that case Excel automactily recognize the name of
columns and data without problem.
But others Excel can't automactily recognize delimiting
character and I need rework to format.
There are some configuration that can fix it?

Thanks
 
You might need to extend your script by using the OpenText method. Check the
online help for VBA for details of this method, which allows you to control
how Excel reads the text file - including the delimiting character.

If this routine is something you'll be using often and for a long time,
using OpenText instead of relying on Excel's defaults is a good idea anyway.
You can't be certain that defaults will be the same from version to version,
or that different users won't have different setups (as you've found out
already).
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top