>A long time since I've done this.
>
>I have a client who has a couple of small processes that they want to convert to Excel macros/VBA.
>
>A couple of tricky issues I've come across:
>
>One of the processes relies on VFP Field() function to get all the field names from the field number (2 to FCount()).
>
>There are about a dozen Replace statements to shuffle fields up (addresses - remove blanks).
>
>Does anybody have any suggestions on how I get around these. They want to move this to the intranet at a later date so I want to get as much of the processing on query results done locally.
>
>TIA,

Convert this code to ADO which should work just fine in Excel. The alternative is to create a VFP COM Server that would do the processing.