Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving workbook sheets to individual excel files
was it like:
for each ws in worksheets ws.copy next keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Thom" wrote: I had recently written a vba procedure that saved all active sheets in the active workbook to individual excel files for distribution. Our IS department recently updated Office to SR-2 and my code is gone. I've rewritten the code, but it's not working as it did in the past. Normally I would paste what I'd written here, but my usually laptop is in for service. It was a very short piece of code (and one of my first -and it worked!), so I bummed that I can't recreate. Any assistance would be greatly appreciated. I will post the code I"ve got when I get my machine back! thanks, Thom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto saving sheets from a workbook as separate files. | Excel Worksheet Functions | |||
copy&paste 28 individual files into one file/28 work sheets | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Saving worksheets within workbooks as individual files | Excel Worksheet Functions | |||
Creating Individual Excel Files from Sheets | Excel Discussion (Misc queries) |