Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel for Mac > Macro save wshe...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 324 of 333
Post > Topic >>

Macro save wsheets separate xls files error

by "Jen" <iDocs@[EMAIL PROTECTED] > Apr 23, 2008 at 05:33 PM

I get a type mismatch?  13 Lines 2 and 5 are giving me errors? I am only 
familiar wirh Word and Access VBA.


If anyone can help please! Thanks



 1   Sub Make_New_Books()
 2  Dim w As Work***
 3   Application.ScreenUpdating = False
 4  Application.DisplayAlerts = False
 5   For Each w In ActiveWorkbook.Worksheets
 6  'In case user doesn't want every work***
 7   ' For Each W In Worksheets(Array("sheet1", "Sheet3", _
 8   ' "Sheet5", "sheet7"))
 9     w.Copy
 10   ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & _
 11   "\" & w.Name
 12   ActiveWorkbook.Close+-*
 13   Next w
 14   Application.DisplayAlerts = True
 15   Application.ScreenUpdating = True

 16   End Sub
 




 2 Posts in Topic:
Macro save wsheets separate xls files error
"Jen" <iDocs  2008-04-23 17:33:09 
Re: Macro save wsheets separate xls files error
"Shane Devenshire&qu  2008-04-27 21:01:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Jul 9 5:45:49 CDT 2008.