SS&C Blue Prism Community

kevin_guillemie · 26-05-16

Hi there, I'm trying to rename a worksheet but i have some errors. Could you help me please ? 'Here in VBA 'Sheets(worksheetName).Select 'Sheets(worksheetName).Name = newName 'ws.Name = newName 'What i put on BluePrism 'First Try Dim ...

kevin_guillemie · 25-05-16

Hello, I need to automate some actions in Excel as : - Change data source of a pivot table - Launch "Calculate Sheet" - Extends formula - Change filter data - Rename Worksheet By delay worries and lack of experiences on blueprism, can you tell me h...

kevin_guillemie · 30-05-16

Well when i click on launch, i open my file manually then i execute my program for simulate a clic which enable macro, it works. How can i do to include this into a program ? There are solutions that i've tried : Create instance --> Show --> Open fil...

kevin_guillemie · 30-05-16

Problem solved for me. Here the code : Dim ws As Object ws = GetWorkSheet(handle, workbookName, worksheetName) ws.Select ws.Name = newName

kevin_guillemie · 26-05-16

Hi James, Thank you for your reply, i have ever checked these details. worksheetName = ""monClasseur"" new worksheetName = ""monClasseurRenamed"" With regards, KG

kevin_guillemie · 25-05-16

Thanks James, this is a good alternative. For a better solution, i cannot launch my macro. Here the exception : ""Internal : Could not execute code stage because exception thrown by code stage: Impossible d'exécuter la macro 'Macro5'. Il est possible...

kevin_guillemie · 25-05-16

Thanks for your replies. Indeed, i have macro blocking issue in Excel. I thought to add a delay of 15 sec with a timer which permits user to Allow Macro but i haven't real parameter to put ""in my wait"". Have you got an idea ? Can i just tell BP to ...

SS&C Blue Prism Community

User Statistics

User Activity

Renamed Worksheet

How launch macro VBA from BluePrism ?

Well when i click on launch,

Problem solved for me.

Hi James,

Thanks James, this is a good

Thanks for your replies.