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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.