Copy paste to new workbook if new wb exists

Hi everyone,

Im running into the following:
I try to copy and paste an output from workbook x to a new workbook y. If workbook y does not exist, the code should create a new workbook and perform the copy and paste routine. This worked but suddenly Im getting an automation error. Further, in case the workbook does exist the copy and paste routine does not work either. Can someone help me out here?

Please Login or Register  to view this content.