Topic Thread

Expand all | Collapse all

MS Excel VBO - "File already in use" on saving workbook

  • 1.  MS Excel VBO - "File already in use" on saving workbook

    Posted 06-19-2020 10:36
    Hello, we are facing a weird problem while saving excel workbook.

    Basically we have a lot of robots saving excel in a common share but each saving their own excel. There's no chance other user/bot is using the same excel. When we preform the "save workbook"  action sometimes (like 50 or 60% of the times) we get na excel pop up saying "file is curently in use" wich just puts the VM in "warning".

    We belive this is something about the 30 secs timeout which is hardcoded on the object but we are not sure. Any idea about this?

    ------------------------------
    Joao Molina
    Intelligent Automation CoE leader
    Millennium BCP
    Europe/London
    ------------------------------


  • 2.  RE: MS Excel VBO - "File already in use" on saving workbook

    Posted 06-19-2020 11:40
    It seems like you are trying to open already open excel.
    You should try to kill excel process in task manager before reopen again the same excel.
    Before starting to work with excel use this;
    Utility- Environment-> Kill Process, Process name=" EXCEL"
    Also you should use kill process after you finished excel jobs. Close instance dont kill excel.exe.You should use kill process.

    or maybe you are using wrong handle value for save workbook object.

    ------------------------------
    Elif Karaoglu
    ------------------------------



  • 3.  RE: MS Excel VBO - "File already in use" on saving workbook

    Posted 16 days ago
    Hi Joao,

    I've experienced something similar. When you say "common share", are you referring to a OneDrive folder or is it a mounted network folder?

    ------------------------------
    Sam Assaf
    Senior
    EY
    Montreal QC
    ------------------------------