Debug error occurring only under a certain set of conditions

[TylerExcel]

Hello Everyone,

First post here. I am having a debug error occur only under a certain set of conditions. Below the bolded/underlined code is where the debug tool highlights the error:

Please Login or Register  to view this content.

When the code first checks if a folder exists based on certain criteria, and a folder IS created, the the debug error occurs on the Bolded/Underlined code. If a folder already exists and does not need to be created, then the code runs smoothly and no debug errors. Another caveat, when the debug error occurs, the save is successful... the file is in the newly created folder.

I am stumped as to why this is occurring only when a folder is created.

Thank you,
Tyler

[AlphaFrog]

I'm not sure what the exact problem is, but the code seems overly complex. Maybe try this...

Please Login or Register  to view this content.

[TylerExcel]

Thank you Alpha Frog with your simplified code. But I am still getting the same error. On your code, the bolded/underlined is what caused the debug error.

Please Login or Register  to view this content.

The debug error only occurs when it has to create a new folder "MkDir". If it does not need to make a new folder, there is no debug error. For example, I ran the simplified code in the circumstance that a new folder needs to be created. I then received a debug error, closed the debug box and performed the same operation. On the second run, a folder did not need to be created (as it was already created on the first debug run). I was prompted if I wanted to overwrite the file, selected yes, and the code ran smoothly without a debug.

On a side note, the pathway folder is a onedrive folder. Could a onedrive sync issue be occurring when a new folder is created, like when it attempts to save on the pathway with a newly created folder, it errors. But an already created AND synced folder does not have the issue?

Thank you,
Tyler

End Sub

[TylerExcel]

What confuses me the most is how there really is no error. When an error code is thrown, the action is still performed (New folder created, file saved in folder). The debug error code should not occur.

Closing out of the debug, re-running macro, saving over file - is the only workaround for the entire macro to work.