Well ... the error code says Excel is unable to locate the path to the file which is named .\VB1A11.tmp

It is strange that the portion of that path begins with a period. Even if there is more to the path than what is displayed (all to the left of the period) it is unusual that portion would end with a period.

I experienced a path error not long ago and the reason was the macro had not created the .tmp (temp) file which was required to exist so the macro could write to the temp file.

Just a few thoughts for you to ponder.

Now ... without reviewing your entire code it will be impossible to determine if there is something needing revision.

On the other hand ... perhaps what you are experiencing is nothing more than an "Excel hiccup". Those are always frustrating.