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