Run time error 424: Object Required in Outlook/Excel VBA

I had this code working and after I put code in to automatically save the workbook on close I am getting this error.

This is the structure. I am autoprocessing emails I receive using a rule in outlook. The rule searches for new mail with a certain subject, moves it to a new folder, and runs a macro in outlook to copy the data from the email body to an excel file. The Excel file has an auto_open macro that appends the new data from each email to an access database, moves the data then to a new sheet, saves the workbook, and closes the file.

So when Outlook is processing the email it stops on this line:

Please Login or Register  to view this content.

Full code:

Outlook

Please Login or Register  to view this content.

Excel code in workbook:

Please Login or Register  to view this content.

Excel Code in module:

Please Login or Register  to view this content.

I haven't changed anything location or name wise with the excel file - just the macro within it. How would I isolate that?

No I'm pretty sure it was the last block of the excel code...

Please Login or Register  to view this content.

So the creation of the second sheet "archived" and that code I believe.

Yes that's correct

Ah good suggestion - I will edit it with that in mind and see if it works. It definitely makes sense.

And yes, I believe you're right as well with doing it all from outlook and I may consolidate at the end here and try. I'm just running against a tight deadline and was trying to get it working before making it as efficient as possible.

I really appreciate your help and will let you know once I try this!

Alright so it all works - you were exactly right!! I took out the two lines:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

And put them into the outlook vba before the xlWB close and I was off and running! I can't thank you enough for your help and second set of eyes on this. Now that it is all working and I have a little more time still and have fulfilled my self Proof of Concept I will incorporate the excel code into outlook and just run it all from there.

Thanks again!