Thanks Perry!! I followed your suggestion and figured out how to code this in VBA. It was pretty straightforward. My biggest impediment was trying to rely entirely on the fragmented VBA online documentation for guidance. Once I got my hands on a VBA book, things came together. This weekend will be devoted to learning more about OLE, and how to use it within a Visual Foxpro program to extract the data directly to a DBF file.


>OLE is using VBA. VBA is the language used to enable OLE. To use OLE, you need to find the VBA code that accomplishes your goal, then translate the VBA to something VFP understands. The biggest difference between VBA and VFP is that VB supports named parameters. In other words you can pass parameters with the parameter list being in any order, but they are named.

Ex. Copysheet before = "Sheet1"

I would think the best way to copy the data, is to find the VBA code to select a range, then extract that data and pull it into VFP