Thread: Error in VBA code to save workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
  
Posts: 1
Default Error in VBA code to save workbook
Try this:

Sub Macro1()
Workbooks.Open Filename:= _
"G:\XXX\Example.xls"
Application.Run ("Example.xls!SecondMacro")
Workbooks(“Example.xls”).Save
ActiveWindow.Close
End Sub

- Piku

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote