Search results

  1. J

    Email formatting(color or bold.....)

    What do you mean by email table in body? How will you know what data you want to highlight and how will you know that.
  2. J

    Get only specific columns from Excel worksheet to Collection using Code stage

    No, the table name will be the name of the table in excel. Select table then go to Design Tab and you will be able to see the name of the table on the left top side.
  3. J

    Excel VBA - Copy Paste As Values

    What do you mean by you want to paste as VALUE?
  4. J

    Get only specific columns from Excel worksheet to Collection using Code stage

    Use the [Header Name] as a single column header name instead of collection. Moreover, in the following line of code replace the myTable with the name of your table in the excel. r = ws.ListObjects("myTable").ListColumns([Header Name]).Range Thanks
  5. J

    How to convert Text that contains two numbers To Two different Numbers

    Np. Hope you can like my solution. :)
  6. J

    Close one of thee two open excel workbook

    You can try closing the previous Excel file using Close Instance action of Excel VBO. give the handle of the previous file.
  7. J

    How to convert Text that contains two numbers To Two different Numbers

    You can get the index of comma using Instr command. Then use "Len" function to get the total length of the string. After that, use Right and Left function to get the number in the left and right side of the comma and save them in different Number data type.
  8. J

    How to save .msg (Outlook mail) as an PDF

    How can we import and use third-party package in BP code? For example, here it needs Syncfusion.HtmlToPdfConverter.QtWebKit.WinForms to be imported in visual studio.
  9. J

    Get only specific columns from Excel worksheet to Collection using Code stage

    Can you please show the ss of your logic and code stage.
  10. J

    Get only specific columns from Excel worksheet to Collection using Code stage

    Copy the action "Get worksheet as Collection" action and make new one named "Get specific column as collection" In code stage copy below code: Dim ws as Object = GetWorksheet( _ handle, workbookname, worksheetname) Dim r as Object r =...
  11. J

    How to check for unresponsive web pages

    Your question is not quite clear.
  12. J

    How to open MS Access using blue prism

    Hi All, I am trying to get data from MS Access using OLEDB but getting one error as below. Can you please guide ms on what can be the issue? error msg: "local host not available"
  13. J

    Spy dynamically using blueprism

    Hi, I am pretty new here so can you please elaborate how to do it? Thanks, Jay
  14. J

    reading data from excel

    Hi Nitin, Thank you for your reply.But I also need the duplicate data as well in separate collection. Thanks
  15. J

    reading data from excel

    I am having the same problem. I have 27 rows of data but my collection is having 31 rows( 4 empty rows). What is the reason for that? it was working find and was readind 27 rows only before I edited the worksheet. Can anyone please help here. thanks
  16. J

    Getting extra empty rows in collection from excel

    Hi guys, I have one problem. When I read worksheets as a collection, I am getting four extra empty rows in the collection. Can anyone please let me know why is it happening? thanks
Top