Help for automation with MS Excel

[Nifrabar]

Hi,

From VFP I can get value from 2nd sheet in ExcelBook by:
oExcel.Sheets(2).select
I think it is possible to achieve this same by using the sheetname.
But I'm struggling with the syntax on that.
Any help?

TIA
-Bart

 

[Mike Lewis]

Bart,

It's very easy. Just do this:

oExcel.Sheets("Sheet2").select

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[JRB-Bldr]

Mike's suggestion is correct.

But have you investigated how to do this yourself by doing the work manually in Excel as part of creating an Excel Worksheet Macro? If you had, you could have gone into that Macro and examined the VBA code and then converted it into VFP Automation code.

Good Luck,
JRB-Bldr

 

[Nifrabar]

Mike,
As quit often.... Too easy. But yes it works.

JRB,
I know you can see how things are going using the macro editor.
Just did not make the connection between sheet(2) and 'sheet2'.

Anyway thanks for replying on my Q.

-Bart

 

[jimoo]

Check out the following FAQ

faq184-4428


Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[Nifrabar]

Thanks for pointing to FAQ Jim.
-Bar