| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Worksheet to new file by tab name
Hi
I need to save a single worksheet from a master workbook by its tab name to a specific folder on my C: drive. The macro needs to extract the worksheet, save it to the c: drive, close the new file and return me to the original file (the master). Also €“can I remove the standard Sheet 1, Sheet 2 and Sheet 3 when creating the new file as they are not required. I have already created the tab name and the folder on the c: drive (C:\Report Logs)and only need the macro to accomplish the above. Cheers Bobzter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a worksheet as . prn text file - record length | Excel Discussion (Misc queries) | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
| Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
| Saving to a worksheet in another file...? | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
Threaded Mode
