Excel Automation Resources

[Guest_imported]

I want to write a program in VFP that would read data in a particular excel sheets and cells but I couldn't find any from the samples any body could help me with this or anyone can point a link to resources of complete excel automation in VFP?

What I want to happen exactly is I will read data in cells from excel sheets. In one excel file I contain several sheets in a worksheet and all of them should be read and compared from the values of my database.

Any help would be appreciated. I need this badly, thanks.

 

[rgbean]

If you installed the sample code along with the help file from the MSDN CD, enter:
DO _samples+"\solution\solution.app"

Then check the sample code in "Automate a Microsoft Excel Spreadsheet" under ActiveX -> Automation. While it doesn't have your exact scenario, it's a good place to start.

Also a couple KnowledgeBase articles might help:

http://support.microsoft.com/support/kb/articles/Q142/1/93.asp

- HOWTO: Use OLE Automation to Add Data to Excel Sheet

http://support.microsoft.com/support/kb/articles/Q252/6/15.ASP

- OLE Examples for Taking Control of Excel from Visual FoxPro

Rick

 

[GrigoreDolghin]

Or you can try the Hentzenwerke Publishing, at

http://www.hentzenwerke.com.

The book you need is "Microsoft Office Automation with Visual FoxPro".

Hope this helps Grigore Dolghin
Class Software
Bucharest, Romania

 

[Guest_imported]

Thanks for the reply, the knowledge base from Microsoft actually helps. I should have read it before. But one more question, I issued a command from the vfp command window as x = getobject('c:\myexcel.xls') but I used to receive the message Excel Ole automation error. What is it supposed to mean? I used to copy this command from the online documentation of vfp. Anybody could explain this to me? Thanks again.

 

[GrigoreDolghin]

You should create the Excel object before, using loExcel = CREATEOBJECT("Excel.Application&quot.

Have you created it?

Hope this helps Grigore Dolghin
Class Software
Bucharest, Romania

 

[Guest_imported]

nope. I just tried issueing x = getobject('c:\Myexcel.xls')

 

[SMCmtg]

Related question. . .can a person automate MS Money into VFP6 like excel or msgraph etc.? THX in advance for your reponse!

 

[rgbean]

Based on a search on the MSDN site -

http://search.microsoft.com/us/dev/default.asp

- it doesn't appear that any version of Money is an automation server. So unless someone who has Money installed came show it can, the answer is probably no.

Rick