Search results

  1. T

    Filter Huge Data

    Hi, I am extracting excel file from web report. After extract, require to exclude one of the columns with criteria. Example ColumnA <> 'sample' I manage to use Utility Collection --> Filter Collection. Then I use MS Excel VBO to write the collection and save it after filtered. Is working...
  2. T

    global send keys

    thanks @sahil_raina_91 , I actually have tried. Issue solve now. Have to apply lower case. Upper case won't work.
  3. T

    global send keys

    the shortcut key will be ALT key follow by D then L
  4. T

    global send keys

    Is still not working. Bot will ALT then input text DL.
  5. T

    global send keys

    Hello I would like to run a shortcutkey from a java base application. I came across this post : I try to apply but is not working. When I try the shortcut key manually is working fine. Is my expression below correct? I try both...
  6. T

    read last row

    any one able to give idea bout my issue here?
  7. T

    read last row

    I have java base application. I would like to read the last row. I try to apply DOWN, then focus and click center but it keep going back to first row. Arrow Down is working fine. How can I fix this? Numbers of row are dynamic, sometimes can be 2 sometimes can be 3, etc.. Would like to read the...
  8. T

    spying dropdown java mode

    Hi, any sample or advice how to spy the java mode drop down? I manage to spy the View but I am not sure what to select in the navigate. I would like to select View --> click Report Below are my elements. How do I add to select Report in the drop down?
  9. T

    Rename File Name

    Thanks. Is working fine.
  10. T

    Rename File Name

    Hi, I download few files save into a folder. How can I rename all this dynamic file name to specific name? Rename file1 to report_sample01.xlsx, file2 to report_sample02.xlsx, and so on.
  11. T

    Renaming multiple file names in the data collection stored in Current values but not in the Initial Values.

    Hi, Data Item: filename (Text) Value: PSS_5_ITEM_O_02052019_0705 The value need to be input? How can I rename directly from the data collection? Is that possible? Because everytime I download the will have multiple files with random numbers (filename_date_xxx). I would like to rename the...
  12. T

    Could not check if drop down exist in scheduler

    It is still not working. Any advice?
  13. T

    Could not check if drop down exist in scheduler

    I have try to remove the attributes. Working fine when I run it manually. Upon running in scheduler it hit the same part, dropdownHTML not found. Any advice?
  14. T

    Could not check if drop down exist in scheduler

    anyone able to solve or suggest this issue?
  15. T

    Could not check if drop down exist in scheduler

    Hello, I have a process to select from drop down list in web browser (IE). Upon running it manually it is working fine. But when I schedule it scheduler I hit error it could not find the drop down list. I have apply the wait button. Anyone able to assist me to solve this.
  16. T

    Report extraction in scheduler

    I have a process where it open in IE, input start and end date, extract report. In my object, launch IE and I applied check if windows activated > yes > input date > extract > save. In process, I call the object to launch and another process to input dates. Upon running it is successful. But...
  17. T

    No elements match the supplied query items.

    Hi, may i know how you solve it?
  18. T

    how to copy file name into varible

    Hi, sorry I don't get it. Can you show the screenshot with steps that you apply inside. I manage to get the Files as collection. How can I read the files name?
  19. T

    scheduler not working

    Hi, I created to read excel, and populate the input into spy elements. It is successful in process upon running. When I try to schedule it in scheduler, it hit error 'file not found'. I use as below: MS Excel VBO --> Open Workbook May I know why? Any solution for this?
  20. T

    Save Email

    Hi, I am trying to save outlook .msg. This is my method: 1)MAPIEX --> GetMail 2)MAPIEX --> ListMail, output collection IDs 3)Outlook Email VBO --> Save email as file, entryID are from the collection Im getting this error upon saving. Internal : Could not execute code stage because exception...