Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Word Table --> Fox Pro code ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00740670
Message ID:
00743262
Vues:
40
Terry,
Thanks very much again. I have used the macro recorder many times. Recently,however, I ran into this form

http://tram.east.asu.edu/forms/downloads/epa/pc/epa-424.doc

which left me wondering if there was a way to convert an existing word doc with its table into vfp automation code.

By the way, would you know how to covert this bit of VB code -- taken from a macro recording of opening a text file in Excel -- into VFP code?

Workbooks.OpenText Filename:="C:\d\tax\200210.txt", Origin:=xlWindows, _
StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(14 _
, 1), Array(42, 1), Array(67, 1), Array(70, 1), Array(83, 1))

The above code seems to duplicate the act of appending in a text file into a vfp table, then using the replace command to sutff a series of fields, based on the knowledge the text file stores data in fixed width columns.

Steve


Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform