View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SteM SteM is offline
external usenet poster
 
Posts: 3
Default Importing csv by code

Hi there,
i wrote some vba code to open a csv file within Excel 2000.
Since the separator is ';' and not ',' i wrote:

Set wb = Workbooks.Open(FILENAME:=filename, ReadOnly:=True, Format:=4)

But the file is not imported correctly.
BTW: if i double-click on the file, Excel are not able to import it but if I
open the file within Excel, the file are ok.

Any idea?
--
SteM