Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh pivot data automation
Hello,
I have an excel file with several pivot sheets (from source Access query) that I need to refresh the data once a day every 6:30AM. I was able to create a scheduler task in Windows XP to open the file at 6:30AM every morning, but I need to run the refresh all macro in the excel file instead. How do I program in VBA or how to do what I want? Thanks Also, I want in the sheets to show date/time stamp of when the data was refresh. Don't know how. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh pivot data automation
For Refresh all Pivot Tables in a Worksheet, see this:
http://www.ozgrid.com/VBA/pivot-table-refresh.htm Now, for the time stamp, just do something like this: Sub Macro1() Range("J1").Select ActiveCell.FormulaR1C1 = "=NOW()" Range("J1").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False End Sub Well, you get the idea. HTH, Ryan--- "Cam" wrote: Hello, I have an excel file with several pivot sheets (from source Access query) that I need to refresh the data once a day every 6:30AM. I was able to create a scheduler task in Windows XP to open the file at 6:30AM every morning, but I need to run the refresh all macro in the excel file instead. How do I program in VBA or how to do what I want? Thanks Also, I want in the sheets to show date/time stamp of when the data was refresh. Don't know how. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) | Excel Programming | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
how to refresh pivot data | Excel Discussion (Misc queries) | |||
Pivot table Data refresh | Excel Worksheet Functions | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |