mpewsey
11-17-2005, 04:13 AM
This is probably a very simple one but it's got me stumped!
I've got a workbook which contains a number of sheets. All I want to do is create a new workbook with just one of the sheets in it (it'll be the active sheet) and save this to a specified location.
I thought it would be easy to do with VBA but I just can't think how to do it.
Thanks for your assistance
Martin
I've got a workbook which contains a number of sheets. All I want to do is create a new workbook with just one of the sheets in it (it'll be the active sheet) and save this to a specified location.
I thought it would be easy to do with VBA but I just can't think how to do it.
Thanks for your assistance
Martin