I have a worksheet of data in my workbook.

I want a macro that basically copies the data (Paste special values and formats) to a new workbook. There's also a chart on the sheet that i'd like to copy over as a bitmap.

The macro that will do this may be run multiple times so I need away that won't reference a filename when creating the new workbook.

I don't need to save it anywhere or anything like that, just copy values, formats and the chart.


Thanks