Hi,
Attached is the macro that is built to create a report.The run time is about 30 mins.But during the code execution, excel automatically closes all the workbooks abruptly. Looks like this issue is related to cache/buffer since I can see a clipboard pop-up appearing on the right bottom corner showing 16 of 24- Clipboard in the middle of execution. I'm assuming once the clipboard is filled up, the macro terminates and closes the application. I had once entountered with an error message that says "the picture is too large and will be truncated". The clipboard content is a list of 'no preview available'
I found some solution on the internet and found the code for clearing the clipboard programatically, it didn't help. Application.cutcopymode=false is not helping either.
Any suggestion would be appreciated.
Thanks