Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finish one App before closing??
How do I get this to finish the refreshing the pivot table before trying to save and then close excel???
THANKS IN ADVANCE!!!!! Sub Auto_Open() ' ' Auto_Open Macro ' Macro recorded 6/23/2004 by Tetris ' ' ChDir "T:\Data" Workbooks.Open Filename:= _ "T:\Data\test.xls" ActiveSheet.PivotTables("PivotTable1").RefreshTabl e ActiveWorkbook.Save ActiveWindow.Close Set excelApp = GetObject(, "Excel.Application") excelApp.Quit End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing workbooks w/o closing Excel | Excel Discussion (Misc queries) | |||
Finish Spreadsheet | Excel Discussion (Misc queries) | |||
Finish this sentence | Excel Programming | |||
closing excel after closing a workbook | Excel Programming | |||
Need help to finish function.... | Excel Programming |