>I had tried that earlier, but was getting some complex VB code which was not running through VFP.

I didn't say you can run it 'as is'. You've to analyze it and convert to an VFP equivalent. VBA passes all parameters by name but VFP supports only positional parameters. You have to use VBA help for proper conversion.