How To Finish pivot table refresh before cont. VBA code

G

graham

First off, thanks for all the help from everyone in getting me this far!!

I'm so close to finishing this but have one problem, I'm trying to Auto_run a macro in a different workbook that opens an existing file, refreshes the pivot table, saves, then closes excel completely. My only problem is that my code trys to close excel before the refresh is complete. How can I tell it to finish the refresh operation before continuing?

THANKS!!!

ChDir "T:\Data\"
Workbooks.Open Filename:= _
"T:\Data\file.xls"
ActiveSheet.PivotTables("PivotTable1").RefreshTable
ActiveWorkbook.Save
ActiveWindow.Close
Set excelApp = GetObject(, "Excel.Application")
excelApp.Quit
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finish one section of code before continuing 3
Finish one App before closing?? 0
Pivot Table refresh in VBA code not working 0
Refresh Pivot Table: Do you want to replace the destination cells 2
Pivot Table(s) - refresh in sheet - macro - automate 6
How to modify the sql statement on a pivot table using VBA- XL2000 1
VB Pivot Table Refresh Excel 97 2
Wait for Pivot Refresh before continuing Code Execution 0

Top