Thread: SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
JingleRock[_2_] JingleRock[_2_] is offline
external usenet poster
  
Posts: 45
Default SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003
On Jul 18, 4:45*pm, JingleRock wrote:
On Jul 18, 11:23*am, "Don Guillett" wrote:

Sub saveworksheetandgooon()
Application.DisplayAlerts = False
Sheets("Sheet10").Copy
ActiveWorkbook.SaveAs "Sheet10.xls" * * * '<<< this has to be a WB other than the Active one -- see my code below
ActiveWindow.Close
Application.DisplayAlerts = True
End Sub

Don,

Is there something special about the name "Sheet10"?
See my following post.

Chuck
Reply With QuoteReply With Quote