Thanks. I got the attachment. Tested it but on reload, it does not pop up the message and also does not export the file into the said path. When I test the macro without reloading, it is popping up the message ‘done’ but no export to file path is done.
Find the attachment. I have changed the code to create a excel and export the chart(previously it just copied the data in existing file). Forget the about the message, i just used for debugging. i removed it.
Your application works but when I copied the macro into my application, it hits error on the clear all and when I commented the clear all, it encounters error on the next statement.
