excel open specific sheet Topic is solved

[Lapas]

im using:

Code: Select all

Pathy= %A_WorkingDir%\new.xlsx
X1X := ComObjCreate("Excel.Application")									X1X.Workbooks.Open(Pathy) 
X1X.Visible := true

-at excel new.xlsx i have many sheets i need to know how can i open specific sheet for example open me second sheets, his name is JFK.

-and second question if is possible open excel new.xlsx and make new sheets with command

[TheDewd]

Example:

Code: Select all

#SingleInstance, Force

ObjExcel := ComObjCreate("Excel.Application")
ObjExcel.Visible := True
ObjWorkbook := ObjExcel.Workbooks.Add()
return

F1::
    ObjWorkbook.Worksheets.Add() ; Add Worksheet
return

F2::
    ObjWorkbook.Worksheets(1).Select ; Select Worksheet
return

F3::
    ObjWorkbook.Worksheets("Sheet3").Select ; Select Worksheet by Name
return

[king-of-hearts]

You can try this:

Code: Select all

pathy := A_WorkingDir . "\new.xlsx"
xls := ComObjCreate("Excel.Application")
xls.visible := true
xls.workbooks.open(pathy)
xls.sheets("JFK").select ; selects the sheet
return

[FanaticGuru]

Code: Select all

pathy := A_WorkingDir . "\new.xlsx"
xls := ComObjCreate("Excel.Application")
xls.visible := true
xls.workbooks.open(pathy)
xls.sheets("JFK").select ; selects the sheet
return

I use Activate instead of Select but I don't know if there is a great deal of difference.

Code: Select all

xlApp := ComObjActive("Excel.Application")
xlApp.Sheets(2).Activate	; Can use index or specific name

FG

[Lapas]

thanks guys.. i need solve one last problem:
i need add and rename so i tipe:

Code: Select all

oExcel.Worksheets.Add() ; Add Worksheet
oExcel.Sheets("sheet1").Name := "Summary"

this work!! but i need oExcel.Sheets("sheet1").Name := "Summary" selecet variable sheets soo i try:

Code: Select all

var="sheet1"
oExcel.Worksheets.Add() ; Add Worksheet
oExcel.Sheets(var).Name := "Summary"
;didnt work

Code: Select all

var="sheet1"
oExcel.Worksheets.Add() ; Add Worksheet
oExcel.Sheets(%var%).Name := "Summary"
;this code too didnt work 

i need solve rename how i can choose the name from variable, thanks you anyway

[king-of-hearts]

Code: Select all

xls := ComObjCreate("Excel.Application")
xls.visible := true
xls.workbooks.add()
var := "Summary" 
xls.sheets(1).name := var
xls.sheets(var).select ; selects the sheet