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,