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.
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 |
---|---|
68 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
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.