dBASE Windows API - Select sheet in Excel workbook

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Select sheet in Excel workbook

Trevor Rann

2005-06-03, 3:23 am

Hi all

How do I select "Sheet 2" in an Excel workbook?

I figure something like oExcel.Sheets("Sheet 2").select but this
doesn't work.

Thanks
Trevor

Rick Gearardo

2005-06-03, 7:23 am

oExcel.sheets("Sheet2").select()

When you look at an Excel macro inVB it usualy doesn't have parens but you
need them in dBase.

Rick

"Trevor Rann" <trevor@here.com> wrote in message
news:MPG. 1d0a83e680309b8e9896
80@news.dbase.com...
> Hi all
>
> How do I select "Sheet 2" in an Excel workbook?
>
> I figure something like oExcel.Sheets("Sheet 2").select but this
> doesn't work.
>
> Thanks
> Trevor

Trevor Rann

2005-06-05, 3:23 am

> oExcel.sheets("Sheet2"). select()
>

Thanks Rick, that worked.

Sponsored Links