I want to automate process in which i fill Xlsm file then click on Add ins to create XML file to import it to a company system.Can anyone help me to write code to do this.
I need help to add criteria to autofilter as I'm trying to filter on صيدليه from D column in the sheet in the screenshot but it didn't give me any result noting that i tried also operator 2 and turned on the autofilter Any help please
i want to replace cells value from yes to no after applying filter to excel sheet to be more clear i have excel sheet that contains 5 columns i want to apply filter to column number 2 then replacing the visible cell values of column number 5 from yes...
Hi All,
I'm new to BP and i have issue when I'm trying to configure Email - POP3/SMTP/IMAP I got the error in the attachments, i also attached the configuration step to kindly check if there is something wrong.
thanks in advance.
----------------...
I already filled the xlsm i'm just pending at the step of Add ins creating Xml file How can i use your code starting from the steps of creating xml file?Please determine the inputs and outputs of the code I'm new in blueprism
I tried to set the range with no result also it didn't throw any error also i don't know where is the problem also i tried many time this code Dim worksheet as ObjectWorksheet = GetWorkbook (handle, Nothing). ActiveSheetWorksheet.UsedRange.AutoFilter...
Thanks it works fine and yes the default replace only the visible cellsI just want another help i don't know how to add the criteria to autofilter as it didn't give me any result