Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem opening a csv file
Message
De
03/08/2001 10:24:56
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Problem opening a csv file
Divers
Thread ID:
00539374
Message ID:
00539374
Vues:
50
Hello,

I have a comma separated file with single quote delimiters that I am trying to open in Excel 2000 using VFP 6 automation. I can't seem to figure out the parameter or its position to tell excel that the file used the single quote delimeters. Does anyone know what position it is and what value to use?
Here what I am doing ...
lcFileName = "C:\MyFile.txt"
loExcel = CreateObject("Excel.Application")
loExcel.WorkBooks.Open(lcFileName, 2, 1, 1, 2, .F., .F., .F., .T.)
loExcel.visible = .T.
I have tried variations of parameters and values but can't get it right.
Any help would be greatly appreciated.

Thanks,
-Isaac
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform