I did a search using Ron DeBruin's google addin, asking for save sheet and
got lots of hits
http://tinyurl.com/38zbw

--
Don Guillett
SalesAid Software

"Soniya" wrote in message
...
If I want save those sheets in a new file?



-----Original Message-----
Asked 35 minutes ago. Patience is a virtue. You cannot
back up a sheet
unless you separate it from the workbook.

--
Don Guillett
SalesAid Software

"Soniya" wrote in
message
...
Hi all,

I want to give the users three options to back up
selected sheets from a file like:

from combobox1 of userform 1 list:

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

biut the users would have an option to select just
location not the file name..(File name is fixed thru
code)

How can I accomplish this thru code?

any help..
TIA

Soniya


.