Neat link VJ - then we just need to employ web services for at fully automated DST date xD
I've not yet needed the date and have been utilizing the LocalTime() to keep track of the time.
Another way to get around this is that robots shouldn't get started 00:00 +/- 1h .. Furthermore when robot...
From the description I'd guess that, it's either a memory issue or a handle issue - have you determined the handle for excel?
You can use "Create Iinstance" and "Open Workbook" to determine the handle.
To Clarify - the item retrived will have both tags (Work Type1 AND Customer Type2 AND NOT Work Source1)
If you need to get items with ether Tag, use multiple "Get Next Item"-Actions
There is a small difference in how to shell around the code.
If you want to make a collection from a csv (got that lying around)
you can use (code from Parse CSV):
"
Dim HDRString As String = "No"
If First_Line_Is_Header Then HDRSTring = "Yes"
Dim Folder as String = nothing
Dim FileName As...
Still missing a smart solution for the summer/winter time shifts.
If you use Now()+timezone-x (you have to know the date for when x shifts - In Denmark it's not the same dates every year)
If you use LocalTime(), there is no way to ensure the correct date around midnight.
The format is e.g. “+Work Type1;+Customer Type2;-Work Source1” according to Blue Prism documentation. This example would take a item with the “Work Type1” and “Customer Type2” tags and without a “Work Source1” tag).
We don't experience it - the only thing we can imagine is either that the automate script breaks or the service breaks at a critical time.
I may depend on the type of setup you are running - we are running Remote desktops on a pc with screen in locked room
You can use that (Get Worksheet Range as collection) multiple times and then use "Collection manipulation - Merge Collection" (multiple times?) to form a single colleciton with the desired rows.
here is one way to do that if you can
this process looks for a order number in a table and if it finds it clicks on a link in a different column (same row)
EDIT/ Didn't see that it was only regex you were looking for
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.