Ever wanted to get a bunch of pivot table data on excel files refreshed without the need of opening the file at all?
Here's a solution,
download the zip and extract. To use, just create a batch file and execute the .exe file on command line.
http://search.cpan.org/~ctbrown/Win32-Excel-Refresh-0.02/Refresh.pm
No comments:
Post a Comment