You can use OLE automation with Excel and pretty much do whatever you want with the spreadsheet.
You can find numerous examples here of Automation.
PF
>I have a large, very wide spreadsheet in ecxel that has employee social security number in one column and one blank column for earnings figures. The spreadsheet cannot easily be exported to a table because of its complexity.
>
>
>I have a VFP table with the ss# and the earnings figures. Is there some way to have vfp access the spreadsheet, locate the ss# and write the earnings in the adjacent column? I cant fathom having to do this by hand.
>
>
>TIA
>Chris
(On an infant's shirt): Already smarter than Bush