Select an open excel-sheet

[Marc Vanzegbroeck]

Hi,

I know how to create,open, edit and save an excel-sheet.
But is it possible to select a sheet that is already open?
I want to press a button, and than select the excell-sheet (in case if more than 1 sheet is open) that the program have to modify/use.

Thanks

[joseluisysturiz]

Hi,

I know how to create,open, edit and save an excel-sheet.
But is it possible to select a sheet that is already open?
I want to press a button, and than select the excell-sheet (in case if more than 1 sheet is open) that the program have to modify/use.

Thanks

Intenta asi...

oHoja := oExcel:ActiveSheet() // SINO ESPECIFICAS QUE HOJA, TOMARA POR DEFECTO LA HOJA1

oExAngu:Sheets("COLUMNAS"):Select() // SELECCIONO Y ME CAMBIO A LA HOJA(pestaña) COLUMNAS Q VOY A LEER
oHoja := oExAngu:ActiveSheet() // ACTIVO HOJA SELECCIONADA, SINO ESPECIFICAS QUE HOJA, TOMARA POR DEFECTO LA HOJA1
oHoja:Cells(2, 4):Select() // POSICIONA EL CURSO EN LA CELDA ESPECIFICADA(D8) PARA LEER COLUMNA( row, col / fila, col)

saludos, gracias...

[Marc Vanzegbroeck]

Thank you,

I will try it.

[hmpaquito]

Code: Select all

oSheet:= oExcel:WorkSheets(<cNameSheet>)  

[joseluisysturiz]

Code: Select all

oSheet:= oExcel:WorkSheets(<cNameSheet>)   // Now oSheet == oExcel:ActiveSheet()

Gracias por la informacion, saludos...

[Marc Vanzegbroeck]

Hello,

I didn't get it to work.
Maybe my question was not really clear.

What I want to do is:
- Press a button in my programm
- The program wait till I select the sheet of the excellbook that I want to use (because more than 1 excell-books can be open)
- After selecting the sheet I want to use, the program use that sheet, and get the information of that sheet

[hmpaquito]

What I want to do is:
- Press a button in my programm

ok !

The program wait till I select the sheet of the excellbook that I want to use (because more than 1 excell-books can be open)

Make it in programm shown buttons labeled with sheet names.

After selecting the sheet I want to use, the program use that sheet, and get the information of that sheet

oSheet:= oExcel:WorkSheets(cSheetSelectedFromButton)

regards

[Marc Vanzegbroeck]

Hello,

I tested it with

Code: Select all

 oExcel = CREATEOBJECT( "Excel.Application" )
oSheet:= oExcel:WorkSheets('MYPAGE')
 

but I get an error

• Error description: Error Excel.Application/16389 E_FAIL: WORKSHEETS
  Args:
  [ 1] = C MYPAGE

on the line with oSheet:= oExcel:WorkSheets('MYPAGE')

[Enrico Maria Giordano]

Try this:

Code: Select all

oSheet = oExcel:Sheets( "MySheet" )

EMG

[Armando]

Friends:

It looks like we can use numbers too.

oSheet = oExcel:Sheets(2)

Regards

[Enrico Maria Giordano]

Yes, of course. Items of Microsoft collections like Sheets can be accessed by position number or string key.

EMG

[Jack]

Hi,
If the excel sheet is open by the user.
How is it possible to get the contents for the current active cell with fivewin .
How to know the x,y coord of the cell in the sheet .
Thanks .

[nageswaragunupudi]

Code: Select all

   oExcel   := ExcelObj()

   oCell    := oExcel:ActiveCell
   if oCell != nil
      ? oCell:Value
      ? oCell:Address
      ? oCell:Row
      ? oCell:Column
   endif
 

[Jack]

Greet , perfect,
Philippe