on 2021 Jan 20 12:51 PM
I would like to write the data on 3 opened excel files in difference sheet name but It show me the error about fail to activate sheet on the 1st or 2nd excel.
Thank you.
Atipat S.
Is there any other solution besides open and close excel one by one?
Thank you.
Aitpat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think you have missed to activate the workbook before activating the sheet.
Br,
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Peter,
I already activated the workbook. My workflow's steps
1. Get workbook list--> It gave me the name of all the opened excel.
2. Activate workbook --> No any error.
3. Get sheet list --> It gave me the correct sheets in activated workbook in step 2.
4. Activate sheet --> It gave me an error about out of range.
It possible to activate sheet on the latest opened file only.
Thank you.
Atipat
User | Count |
---|---|
72 | |
11 | |
10 | |
7 | |
7 | |
7 | |
7 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.