Create new work book

[RicksAtWork]

I have finished my first excel VBA app - or so I thought!!!

I've been asked to write a routine that creates a new workbook, copies specific worksheets from the old workbook and then pulls up a save dialog box so that the user can save the new workbook at a location of their choice.

I have no idea how to do this!!!!

Any help would be greatly appreciated!!!

 

[SkipVought]

Hi,

Turn on your Macro Recorder and go thru the process as described.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}