Recent content by Cher

  1. C

    Pop ups on SAP

    Our team executed this solution mentioned on the portal and we were able to resolve our Server busy error!
  2. C

    Excel error: The document caused a serious error the last time it was opened

    Hi, Has anyone faced this issue where 'Open Workbook' action of Excel VBO fails because it takes too long? I got this error in my Production run. When I try to manually open the file i get the warning, " The last time you opened 'filename.xlsx', it caused serious error. Do you still want to...
  3. C

    Filter Collection for negative numbers

    that worked!! Thank you so much. I had tried something similar but looks like the syntax wasn't correct and it kept failing. Thanks for the help.
  4. C

    Filter Collection for negative numbers

    Hi, I have a collection that i am getting through excel with a column "DateDiff". It is the calculated difference between two dates. I want to filter this collection for the DateDiff column for negative values. "DateDiff < 0" is not returning me any results. Looks like those values are getting...
  5. C

    Writing Undefined Collection to excel based on column header

    Thank you RsBhargav and Milind. The solution worked great!
  6. C

    Writing Undefined Collection to excel based on column header

    I have 4 columns in a spreadsheet that I need to paste on another workbook. The size and order of these 4 columns on the source sheet vary. The Column names are consistent. I need to paste the columns on the destination workbook in a certain order going by their column name. The solution that I...
  7. C

    Filter Excel Data By Specific Criteria

    Hi, I tried using the given filter code (copied the code as is) I am getting an error: "Internal : Could not execute code stage: Parameter count mismatch."Please suggest what is causing this and how to fix it? My input file is similar to what VJR had at the beginning (with Number and Name...
  8. C

    Pop ups on SAP

    Can you please share the code?
Top