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,