I am using a scheduled task to open an excel spreadsheet
every morning.Using the Auto_open feature I run the code
below. The problem is that the workbook closes but excel
does not.The sched task then becomes hung and doesnt run
more than once. Any ideas.
Thanks,
jt
Sub Auto_Open()
'
' Auto_Open Macro
' Macro recorded 1/30/2002 by wardlj
'
'
Application.EnableEvents = True
Application.DisplayAlerts = False
Calculate
Application.Goto
Reference:="Query_from_PM3_Standardize"
Selection.QueryTable.Refresh BackgroundQuery:=False
Calculate
Application.ActivePrinter = "\\RRNTPRT1\BmlOffLJ4000
on Ne02:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\RRNTPRT1\BmlOffLJ4000 on Ne02:", Collate:=True
Workbooks("New PM3 Standardize Data.xls").Close
SaveChanges:=True
Application.Quit
End Sub
.