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...
".xlsx" works fine if I only want to filter for Excel attachments, but what if I also want my filter to include .pdf?
Supplementary question, this seems like an obvious user question but I couldn't easily find the answer. Where should I have looked...
I want to add a tag to each queue item from a field in the Collection that creates the queue. In theory I can do this using the 'Tags' field in 'Add to Queue' and the formula [NLG Discontinued Stock Calculations.Product Group Manager Name].
However,...
Interesting! I needed to identify transactions where the different between start and end dates was no more than 3 months so I did this:
(DateDiff([Date Intervals.Month], [RFC Start Date], [RFC End Date]))<=3
I could have used ToDays and 90 as you su...
I think the point was that many people don't remember the numeric representatives of the time periods (Day is 9, Month is 5 etc.) and they're not very easy to find, especially when you're trying to work out something quickly. The numbers are also an...
I found the trick to be that you can't step through a .BAT process in debug mode. I need to click on the Go button and just let it run.
It also uses global send keys to write the path, so special characters need to be replaced with their respective...
It just seems to open the script and does not run it. There is also a Command Prompt::Run BAT. File VBO but that just gives the following error:
Internal : Failed to perform step 1 in Navigate Stage 'Enter Data' on page 'Run BAT. File' - Not Connect...
