Recent content by sheel

  1. S

    How to Convert IST time to UST time.

    Use below code to change current local time to a specific Timezone Input TimeZoneID as Text Output ConvertedTime as Time Dim now As DateTime = DateTime.Now ConvertedTime = TimeZoneInfo.ConvertTime(now, TimeZoneInfo.FindSystemTimeZoneById(TimeZoneID))...
  2. S

    Write custom delimiter text into MS excel

    Hi All, Below method shows writing text into excel ,this is another way to write excel in more efficient way from text file. Input Value : Collection(input collection), Delimiter(#,|,$....), Target(example C:\Temp\Test.txt) C# Code : Create CSV file with Custom delimiter =========...
  3. S

    'Launch' - Value does not fall within the expected range.

    This error is occurs when Resource PC is suddenly disconnected, during execution. Could anyone explain reason behind show as disconnect ? And resource PC get connected own without any touch. Please note this BOT machine VDI.
  4. S

    'Launch' - Value does not fall within the expected range.

    This error internal is display in Work queue , during processing of items and error comes from Navigate action while launching webpage.
  5. S

    'Launch' - Value does not fall within the expected range.

    Hi All, Getting error message intermittent during launching application in Blue Prism. Could anyone help fix for this one. ERROR: Internal : Failed To perform Step 1 In Navigate Stage 'Launch' on page 'Launch' - Value does not fall within the expected range.
  6. S

    Help needed with OLEDB csv connection string.

    Could you please guide what fix you applied for CSV.
  7. S

    Refreshing Pivot Table

    Create As object and call in process
  8. S

    Refreshing Pivot Table

    @maybeccie please refer attachment
  9. S

    Refreshing Pivot Table

    Can you please share error msg, otherwise above screenshot working
  10. S

    work with previous year dates

    I believe previous year date you select from calendar, and calendar having some up or down button to select future or past date. spy from BP and set your counter and click on up or down button of calendar for past or future date
  11. S

    Refreshing Pivot Table

    @sonali H Above code working we need to Pivot table name correctly
  12. S

    Refreshing Pivot Table

    @sonali H @sivagelli I am also getting same error after performing above steps, could you please help me. Internal : Could not execute code stage because exception thrown by code stage: Unable to get the PivotTables property of the Worksheet class
  13. S

    Solved how to Send Mail with collection table in message body??

    string textBody = "<table cellpadding='5' cellspacing='0' style='border: 1px solid #ccc;font-size: 9pt;font-family:Arial'><tr><th style='background-color: #B8DBFD;border: 1px solid #ccc'>Scenario No</th><th style='background-color: #B8DBFD;border: 1px solid #ccc'>Scenario Detail</th><th...
  14. S

    OLEDB with Excel

    DB_SEC_E_AUTH_FAILED error indicates it’s a database authentication issue, check the database file path and try the connection string like this: Conn = new OleDbConnection(string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Jet OLEDB:Database Password=1234", DbPath))
Top