My xlsx file has 5 sheets, I can change fourth sheet content, after change, I save to a new file.
But when I open the new file, I need manual to select the fourth sheet.
How can I change the default sheet to fourth sheet?
Thanks!
update
It`s work! Thank you very much. But still a little question,
first and fourth sheet both select
I want this only fourth sheet select
Simply set wb.active
to the index of the sheet, eg. wb.active = 3
for the fourth sheet.