Run Time Error 424

I have a workbook activated but either it loses being activated somehow when the file syncs with one drive or SharePoint or something or idk

And when I try to add more data to it I get error 424 because supposedly it’s not activated when it totally is

This is mad annoying I’m running code from outlook VBA to create an excel workbook (or open an excel workbook) and then add data to it and then save it.

Really simple concept I’ve done it millions of times but for some reason this one drive or SharePoint sync TRASHES IT COMPLETELY I WANT TO THROW MY KEYBOARD THROUGH MY PC

Is there a question?

Yea idk I’m

RoryA said:

Is there a question?

Click to expand...

like in an excel blender for saving or syncing or opening or closing a workbook that makes it so that I can’t open like 10 workbooks incrementally even if it’s the same workbook after closing it or multiple workbook and add data to it and close it without this 424 error

RoryA said:

Is there a question?

Click to expand...

Like it’s super easy to save a workbooo down but when I do from outlooo with VBA it’s giving me a 424 error FOR NO REASON OMGGGG

Since it appears you don't have an actual question but just want to vent your spleen online, I'll move this to the lounge.