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.

PF

>I've been given about 100 Excel 97 spreadsheets, and would like to extract the data from a particular named range (XDATA) that exists within each spreadsheet, and consolidate it into a single VFP database. I'm sure there's a way to consolidate the data using VBA, but I'm not familiar enough with that product to know where to start. There doesn't appear to be a native way to this in VFP. However, I wonder if anyone knows a way (perhaps using OLE) to do this. Thanks!!