>correct me if am wrong. But the information in the Excel help files deals with all VBA code. Isn't the VBA code different from the fox pro code ?
Jason,
If you wish to have a quick picture of some VBA stuff, open a new excel worksheet. Start the macro recorder. Do some stuff(enter some data, do some formatting, save the file). Click the stop recording button. Open the VBA editor and look at the module you just created. From the edit menu select all and copy. Quit excel. Open any text editor and paste the clipboard into a new file.
You will notice a lot of similarities between VFP and VBA. They say True, we say .T.. We start our collections with a period, they do not. We say ENDWITH the say End With. There are others, but you will see them.
VBA accepts named parameters or reference. The VBA macro editor uses named parameters. You can probably figure out how to edit the macro code. Put that code in a program file within a WITH/ENDWITH and run it using the debugger.

Try it out.