Skip to main content

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 Tue, 02/02/2021 - 14:39

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.

Brian Element Wed, 02/03/2021 - 10:30

In reply to by Clara

Hi Clara,

Thanks for letting me know that this was it.