I have some code which I can open a spreadsheet and populate it with data, but this feeds the first worksheet.

I need to be able to select the specified worksheet.

ObjExcel=OLECreateInstance("Excel.Application")

ObjWorkBooks=OleGetProperty(ObjExcel,"WorkBooks")

ObjSheet=OleCallMethod(ObjWorkBooks,"Open",ExcelFileName)

ObjWork =OleCallMethod(ObjSheet,"Select",ExcelWorksheet)

Variable 'ExcelWorksheet' contains my worksheet name.

This is failing to select it.

I assume I am on the wrong track somewhere.

Any ideas on how to select a worksheet.

Thanks

Colin

The easiest way I've found how to figure out steps like this is to record a macro of the things you want to do and then edit the macro.

All the methods and properties you need get exposed in this manner.

I have tried this, but it does not give me enough information to determine how to do this in OI.

Any other ideas?

Colin

Hi Colin

I think you want call the select method on a range object

oXl=OleCreateInstance('Excel.Application')

oWkbks=oXl-]WorkBooks

oSheet=oWkbks-]Open(filename)

oXl-]Visible=-1

address=$':A:'$':12

this_range=OleGetProperty(oXl, 'Range',address)

x=this_Range-]Select()

Bob

Thanks, but I cant see where the Worksheet name is within this example.

The select applies to a cell range.

I need to be able to select a worksheet, eg Sheet2

Thanks

Colin

Google "select worksheet by name"

Sheet Navigation

View this thread on the Works forum...