I'm loading an excel spread sheet with an embedded pivot table. Getting the excel work book to load is easy, but it seems to require that you manually "refresh data" after the workbook loads. The spreadsheet automatically imports new data from a text file, but the new data doesn't show until you manually refresh...
I'm loading the workbook like this:
sFile = "d:excelstuffpivot.xls"
set xlWorkBk = xlApp.Workbooks.Open(sFile)
xlApp.visible = true
easy as pie, right? How do I make the pivot.xls automatically refresh the cell contents?