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

Error in VBA code to save workbook
 

Sorry

That still generates the same error message whent the line "Workbooks(€œExample.xls€�).Save" is executed......


----- pikus wrote: ----

Try this

Sub Macro1(
Workbooks.Open Filename:=
"G:\XXX\Example.xls
Application.Run ("Example.xls!SecondMacro"
Workbooks(€œExample.xls€�).Sav
ActiveWindow.Clos
End Su

- Piku


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