| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets Back Up
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheets Back Up
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheets Back Up
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheets Back Up
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer data back and forth between sheets | Excel Discussion (Misc queries) | |||
| Extracting Data back and forth between Sheets | Excel Worksheet Functions | |||
| sheets back to formulas | Excel Discussion (Misc queries) | |||
| how do I tell excell 2003 to print sheets back to front? | Excel Discussion (Misc queries) | |||
| Back Up selected sheets | Excel Programming | |||
![Soniya[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
