| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desktop Folder To Workbook
Hi
I have a folder on the desktop named CARD within the folder there are 20 single sheets all with a different name e.g. OB1, OB2, OB3 etc is it possible in VBA to copy all the named sheets into a new workbook named 'Sue' in the correct order of the sheet tab Ob1, OB2, OB3 etc and at the same time delete sheets 1 to 4 that open in the new workbook 'Sue' I could then assign the macro to a CommandButton. -- Many Thanks Sue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Worksheets save new file to Folder on Desktop | Excel Programming | |||
| Any problem if i move a shared folder from my desktop to d drive | Excel Discussion (Misc queries) | |||
| Values to a folder name on desktop | Excel Discussion (Misc queries) | |||
| Saving a workbook into the desktop | Excel Programming | |||
| workbook creates desktop shortcut...HELP | Excel Programming | |||
Threaded Mode
