Recent content by Pramod Singh Kushwaha

I am using this code , so needed help in placing the dll file and whats the dll and namespace to be added in blueprism initialize page

Sub Flatten_Folder() Dim MyFile As String Mypath = InputBox("Enter the path to the folder where the PDF files are Located **MUST END WITH \**") MyFile = Dir(Mypath) Do While MyFile <> "" If MyFile Like "*.PDF" Or MyFile Like "*.pdf" Then Fullpath = Mypath & MyFile Set App =...

Does any one have code to convert the pdf to flattened pdf using code stage, Also needed dll and namespace to be used.

i am passing the macro code in String_Filter

Blueprism would be better. so that i can write in code stage currently i am using this code Dim wb,ws,sheet,excel As Object Dim arr(11) as object arr(11) = String_Filter.Split(",") Try wb = GetWorkbook(Handle,Workbook) ws = GetWorksheet(Handle,Workbook,Worksheet) wb.Activate() ws.Activate()...

Hi everyone , can anyone help me with how to filter pivot table fields. with multiple selections . The micro code is below ActiveSheet.PivotTables("PivotTable1").PivotFields("[Time].[Month].[Month]"). _ VisibleItemsList = Array("[Time].[Month].&[2017]&[11]", _...

Hi, As of now I don't have access to view macro that's a big problem.. or else I could invoke the macro from BP.. If any general code to double click on particular cell that would help alot.. Thanks..

It is xlsb file. The requirement is double clicking on a particular cell which has "?" And on double clicking the cell , a pop appears (pop can be spied through BP ) but unable to spy the cells.. So it will be great if someone could provide the code for double clicking the cell..