HelloI would like to save an excel file with a "read only" protection. This means the next person who opens the file can only read the document and not edit it. I tried the Action "Protect Workbook" but I didn't manage to make it work. Is there any t...
Hello I would like to sort the column M in ascending order in this Excel file. I was able to turn on the filter on Row 10 with the Action: "Turn on Autofilter". But then when trying to apply the "Add Sort to Autofilter" action, nothing happens. Is it...
Hello,I have this issue, that when i open my desired website on Chrome i have to select the certificate. The problem is I can't spy that popup with Browser mode. Is there any known work around for this PopUp?
Hello I have encountered an error when inserting a "SUBTOTAL" formula in an Excel sheet.If I use the formula for example "=SUBTOTAL(9;Q1:Q10)" i get following Error:Exception from HRESULT: 0x800A03ECIf I use a "SUM(Q1:Q10)" formula it works perfectly...
So if I use the MS Excel VBO (Version 10.1.10) Action "Get worksheet as collection" with the Fetch Data With Method = "Text", it takes forever to read an Excel file with 3k rows. If I use the Fetch Data With Method = "Value" it just takes seconds.
M...
The Excel file has 30 columns which are mostly filled out. And with forever i mean it takes around 10 mins to execute this action. The weird thing is on the older version of the VBO it was possible to read the entire file in matter of 2-3 seconds (I ...