Excel Macro File getting corrupted 1

[pieswt]

Hello all,

I have a excel file with some macros to process and export data to another excel file. Both the files are stored in one-drive (as multiple users need to work on it). The macro works fine for few times but after some time it starts giving this error:

When I click End and try to save the file it says the file is corrupted and needs to be repaired. After I repair the file and save it on local folder, it works fine without any error.

Can someone help me to avoid the error and the file doesn't get corrupted in shared folder?

 

[1503-44]

Might be associated with shapes or slides
Are you using any shapes, slides?

https://duckduckgo.com/?q=excel+runtime+error+2147188160&t=brave&ia=web

--Einstein gave the same test to students every year. When asked why he would do something like that, "Because the answers had changed."

 

[DanKile]

You could be doing an operation that is faster than one-drive can sync files. From the error, it looks like the macro is trying to close excel before one-drive has finished. You could add in a delay before the quit command to see if it helps. If there is a one-drive object in vba to check its status so the macro knows it is safe to quit would be a better option.

 

[MintJulep]

Maybe this could help.

https://exceloffthegrid.com/obtaining-the-save-status-of-a-file-using-vba/