Hi guys, I want to merge different excel in one excel and separate with different tabs, I follow YouTube to do, some times it works, some times the result missing one tab, could you help me to check where is wrong? Just like below pic, this spreadsheet missing [Sheet2], some times missing [ Sheet3], some times it doesn’t missing any one. The missing tab is unstable but will happen test-merge.zip (27.4 KB)
.
Could you help me to find where have the problem? Thank you guys!
You are using the excel scope activities so sometimes it may cause the issue too so if possible use the workbook activities instead of excel.
Excel activities will open the excel file and then only it runs the operations where as workbook activities won’t open the excel. So, try to use the workbook activities.
Inside the “Excel Application Scope,” you can add various Excel-related activities such as “Read Range,” “Write Range,” “Get Cell Color,” “Filter Table,” etc. These activities allow you to perform actions like reading data from Excel, writing data to Excel, formatting cells, filtering data, and much more. The “Excel Application Scope” activity ensures that the Excel application is closed automatically after the activities inside the scope are executed. This helps release any resources used by Excel and keeps your automation efficient.
I also have other process to do just like run the macro, use VBA to change the tabs name and so on. Do you think I can go on use excel scope function? I am worry about it will cause some mistakes, thanks.
Hi @vrdabberu , I have another question is related to invoke VBA, but give me the error code as :0x800a9c68. Do you think this error information is same with I use excel file activities? Or can I use workbook to invoke VBA instead of excel scope? Thank you.