Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Word Table --> Fox Pro code ?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00740670
Message ID:
00743262
Views:
39
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


Previous
Next
Reply
Map
View

Click here to load this message in the networking platform