Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to copy several worksheets to a new workbook, save the new workbook
with a particular name and then close the new workbook (keeping the existing workbook open). the code i have works fine for one workbook (though i haven't gotten to the closing the workbook yet). how can i adapt it to include the other worksheets (sheets 4, 5 and 11 in this case)? <BEGIN VB CODE Dim dir As String Dim wkbk As Workbook ActiveSheet.Copy Set wkbk = ActiveWorkbook With wkbk.Sheets(1).UsedRange ..Value = .Value End With dirstr = ".\orders" On Error Resume Next MkDir dir On Error GoTo 0 wkbk.SaveAs dir & "\" & workOrderNumber & ".xls" <END VB CODE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I save only active worksheet without save all of worksheet | Excel Worksheet Functions | |||
specified time / copy worksheet + save | Excel Worksheet Functions | |||
How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
Automatically save a copy of worksheet from C: to Network Drive | Excel Discussion (Misc queries) | |||
Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions |