Error while exporting to excel.

4 posts / 0 new
Last post
Clara
Offline
Joined: 03/16/2020 - 07:57
Error while exporting to excel.

Hi, 
I am trying to run a macro in which I export an .IMD to an excel. Th epoint is that I am overwritting the same excel. I mean, I export the same excel for several times, with the same name. But sometimes I get the following error:
The .excel is beeing used or is just a reading file or  another thing I can`t remember now.
Do you know why sometimes the code throw me this error but not always? like it depends on the luck I have that I get the error or I don`t.
 
My objetive is to communicate with the exterior (python script) the different points of the IDEA script I am running by overwritting this excel. and reading it with python. 
 
Thank you very much

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Any chance that the excel file is open in excel or by another application.  If it is open then you would probalby get this error.  Also if you have an application reading it and it doesn't properly close it that might also cause this error.

Clara
Offline
Joined: 03/16/2020 - 07:57

Hi Brian!
Thank you very much!. Definitely was that the error.
Thanks you again!

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Clara,

Thanks for letting me know that this was it.