Dear all, i’m trying to write a bot that will run excel, multiple worksheets.
on each worksheet, to copy a particular range then add into a data table.
so after i realised how difficult it is to read sheet name, i did a keyboard shortcuts instead. However i encounter error when i read range workbook because i was opening the workbook. (Which i needed as it is a VSTO file (like system) in order to run the worksheets). Help! Appreciate for any help!
(i even tried using Use Excel etc. but i encounter another set of errors.) T_T
Hello @winnie_toh ,
When you are using Using Workbook Activities like Read Range WOrkbook, The Excel Files should not be open, So close all the Excel Files and then try using the Activity.
THe Alternate way is to use the Modern Excel Activities :
For now, can you try it to put Shortcut activity to send ESC before ReadRange?
OR, in many case, it’s unnecessary to use shortcut. I guess you tried to get Sheet name before ReadRange. However we might be able to get each sheet name using ForEachExcelsheet or Classic Get Workbook Sheets activity.
So, first, can you try to remove shortcut and set sheet name statically, then check if solve this issue. If it’s solved, try to get sheet name dynamically.