New profile posts

Hi members,
Code stage For the Convert data to table format

Dim wb, ws As Object
Dim excel, sheet, range As Object

Try

wb = GetWorkbook(Handle, Workbook)
ws = GetWorksheet(Handle, Workbook, Worksheet)
wb.Activate()
ws.Activate()
excel = ws.Application
sheet = excel.ActiveSheet
range = sheet.Range(Reference)
sheet.ListObjects.Add(1,range, ,1).Name="Table1"

Thanks & Reagrds
Aditya Bankar
Hi members,
Code stage to Colour your table
Dim wb, ws As Object
Dim excel, sheet, range As Object

Try
wb = GetWorkbook(Handle, Workbook)
ws = GetWorksheet(Handle, Workbook, Worksheet)
wb.Activate()
ws.Activate()
excel = ws.Application
sheet = excel.ActiveSheet
range = sheet.Range(Reference)
sheet.Selection.Style = "60% - Accent3"

Thanks & Reagrds
Aditya Bankar
Hi members,
code for the Style Your Pivot table code stage
Dim wb, ws As Object
Dim excel, sheet As Object
Try
wb = GetWorkbook(Handle, Workbook)
ws = GetWorksheet(Handle, Workbook, Worksheet)
wb.Activate()
ws.Activate()
excel = ws.Application
sheet = excel.ActiveSheet
sheet.PivotTables(PivotName).TableStyle2 = "PivotStyleMedium1"

Thank and Regrads
Aditya
Hi members,

Any wants to code for the Refresh Data on the file open. or want to reduce the size of file you can use the following code stage i am sharing the code
Dim wb, ws As Object
Dim excel, sheet As Object
Try
wb = GetWorkbook(Handle, Workbook)
ws = GetWorksheet(Handle, Workbook, Worksheet)
wb.Activate()
ws.Activate()
excel = ws.Application
sheet = excel.ActiveSheet
sheet.PivotTables(PivotName).SaveData = F
A
ADITYA_RPA
last two lines
sheet.PivotTables(PivotName).SaveData = False
sheet.PivotTables(PivotName).PivotCache.RefreshOnFileOpen = True
Hi Karan ,

Is shared inbox working for you ? Am trying to move email of sharedinbox to subfolders but its giving error "object reference not set " . Can you share the solution for this please.
Hi All,

Can you please guide me how to concatenate two fields in a collection.
EX :
I have a Employee collection with two fields.
column A. F Name
column B. S Name

I want results in
column C : F Name S Name.

Thanks !!!
A
Amarender
Hi Birabrata

If no space required in between them, then in Calc Stage use this function [F Name]&[S Name]
If Space required in between them, then in Calc stage use this function [F Name] &" "& [S Name]
Is there any option to check if one collection is empty or not other than using 'Count Row' action from internal VBO 'Collection'?

It is an undefined collection. As per the business scenario, sometime the object will get some value from the target application and put it in the collection and sometime it is not when the application is not having any value.

Please suggest.

Thanks,
Sourabh
S
Sachin_Kharmale
Hi Sourabh,

Use following line of code to check collection is empty or not without using Row Count Function.
Put bellow code in code stage it will return true or false

Dim flag as Boolean = false
if Input_Collection Is Nothing
flag=true
End If
IsEmpty=flag
Hello mrs Camicat, i red you're from Italy like me. If i may, i would ask an advice about a problem i'm facing with BP Outlook VBO. I'm using BP 6.4.1. When i try to run a robot based on this VBO, BP tells me there is a code error, to check errors list, but my error list Is empty and i don't modify or add any code to the vbo. Could you please help me? I really Need this robot work on PEC emails. Ty very much in Adv
Unable to fetch data from SQL Database,

Error being thrown as Unable to cast certain values into the collection.

Please help on the following.
Hello RDawson,
How to download AD01 certificate under BP portal ?
Under LMS portal, there is no such option .

Please advise
Hi All,

Need a help to figure solution for a interview question on BP. as I am just started to learn, this would help me understand better.
1. What are all the key attributes which can be used for effective spying of an element (HTML, Win32 mode)
2. Suppose if there are 4 pages for an application, how many many objects can you create?
3. Features available in BP v6 over v5.

Please help with answers guys. Thanks.
M
Murrali Sundar V
Hello Guys,
It would be a great help if someone help me understand these questions.
Automation Anywhere Enterprise can be used for below reasons:
•No programming knowledge is required. You can record your actions, or point and click the action wizards.
•Eliminates the element of the human error
•Increases transaction speed and allows to save time and costs
•Helps you to automate data transfers and import or export data between files or applications.
•Scale from Desktop to Data Center
How to spy elements of Active Directory via Blue Prism
A
aditi24garg
I am able to launch active directory(AD). However, i am unable to spy its elements. Could someone guide me through it. Or else let me know, what specific changes need to be made in the code stage of the Utility of System-Active Directory. To enable us to add users into AD groups.

Thanks,
Aditi Garg
How to send particular attachment to particular mail, Using loop to continue the process
E
emayan90
In Automation Anywhere tool ?
E
emayan90
• If you want to attach any file type, click the 'Attach' button.
• If you want to attach values of all variables, click the 'Variables' button*.
* Available from version 8.1 onward
This will append a text file that lists values of all the variables (System and User Defined) used in
the TaskBot / Meta Bot Logic.
Note: The System Variable Excel Cell will not be attached as the values input are dynamic.
E
emayan90
Or Else create VB script and execute with AA
Top