We are transitioning to use SharePoint as the file location for our bots to use. I've managed to navigate folder structures in SharePoint using a bot process and identify/download files OK using the Microsoft Graph - SharePoint VBO.I'd like to perfo...
I'm using Browser automation, using Edge and BP v7.1.1.If I use 'Get Attribute' and the Web Y attribute to get a Y-axis number value.Then use that Y-axis number value in the action: 'Global Mouse' Click Y to select the row.It clicks on a different ro...
This wasn't at all obvious to me so I thought worth mentioning:
When using the VBO Command Prompt : Run BAT. File, it doesn't work if you step through it in debug mode. You have to run the process using the Go button and take your hand off the mouse...
All I get is: "The parameter is incorrect" (see attachment)
handle: [Boris]
Workbook name: [Duplicates File]
Worksheet name: "Sheet1"
Range: "A1:C10"
Column Indexes: "0,1,2"
I attach an Excel spreadsheet to my process completion output reports which has the details of the run taken from the queue. The Excel spreadsheet is created by pulling Queue data into a Collection and then writing it to Excel. It could have any nu...
Further to the Microsoft Graph - Excel topic. I am wondering why there in no 'Create New Workbook' option. And also why there is no 'Save' or 'Save As' or Close (Save - T/F) options?
Apologies for the delay, I've been on Jury service this week. I thought I tested it pretty carefully before I submitted that but will try again next week. Your examples look promising.
Scrub that, Workbook ID is just File ID. However I can't find Worksheet ID.Get Worksheet Name doesn't return the name or the ID, just 'Position' and 'Sheet Exists'.Also note that 'Worksheet Exists' doesn't work if the worksheet name has a space in i...
Thanks Eric, I downloaded the Microsoft 365 - Excel VBO and it looks much better. I can Authenticate fine.However, I still can't see how to open a workbook. In particular I don't know what 'Workbook ID' is. I have a file ID from Microsoft Graph - ...