Back Up selected sheets
 

Hi All,

I want copy selected sheets to a new file for the file
name is defined already.. when a user select from a
CombBoxo1 in a user form i want to give them three
choices..

1: Floppy disk
2: Hard Disk (C:\Bkup\) fixed location
3: Other location

in all the three cases i want to keep the same file name,
so that users do not have an option to change the file
name. they can just select the location..

How can i accomplish this through code?

TIA
Soniya