Search results

excel.ActiveSheet.PivotTables(PivotName).PivotFields(PivotField).PivotFilters.Add(Type:=12,Value1:=value) Try this

Not 100% sure but I think you will have to write some code using the AutoFilter method

If your document is just a regular document the Find action should work I have no idea why it wouldn't work for you.

Check out this thread.

AddDays(FormatDate(Today(), "ddd, d MMM, yyyy"), 2)

Your question is very vague but you can try using the Blue Prism "Data - OLEDB" business object. Open up an action, select the "Data - OLEDB" object then click the blue information icon. Read the docs. It's pretty easy to use. If you get stuck with the connection string take a look at this.

If your version of BP works with Chrome you can do what I did. 1. I passed the destination URL from the process down to the Object 2. In the Launch action I provided the destination URL in the "CommandLineParams" input. This will cause Chrome to navigate to the provided url when first opened...

Not exactly sure if this helps your situation but the release notes from BP 6.6 in the updates says something along the lines of: Blue Prism was unable to interact with Chrome or Firefox when processes launched a locally installed application followed by a browser-based application. This issue...

This post might be able to help. Not 100% sure though.

Not sure if this will help or not but there is a url you can enter into your local browser when BP is running that will return the resources and their current status. I can't remember it off hand but if this makes sense at least you can head in the right direction

I don't remember the exact action name for sure but, when you first get a lock it outputs a token which should be saved locally. When attempting to release the lock you need to provide that token as an input to the release lock action. I would check and make sure that is being done correctly.

Okay. From what I understand you should always try Global Send Keys first. Events are only supposed to be used as a last resort

By any chance did you Activate Application before using Global Send Keys? This is done to make sure the keys are being sent to the correct application. If this doesn't work can you tell us exactly what happens when you use Global Send Keys?

If you need help can you post screenshots please?

The "Get Next Item" Action should have an output of "Item ID". This is the text the you will place in the "Set Data" Action input of "Item ID".

I did it with a Code Stage and Visual Basic. It seemed like that would be the easiest way to do it.

B

Might be a dumb question but are you running this without either an open instance or an active document?

I had the file open so I just attached to the open instance of Word. I did the following: MS Word VBO->Find Text - Searched for "[Friend]" which highlighted the found text. MS Word VBO->Type Text - Replaced the found text with the friends name. See screenshots. Not sure if this will be the best...

It depends on what you're talking about. Attach just connects your Business Object to an open application. If you're talking about Attach in the Excel VBO, this will attach to an open instance of Excel. Your question is kinda confusing but if you Launch an application your BO is automatically...