top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Automate refresh and saving of Excel Power Pivot

0 votes

have seen a few threads on here and other sites which offer bits of a solution to what i'm trying to do, but struggling to bring it all together in one nice package. As part of a (at least once a day) daily data load, an Excel 2013 Power Pivot report is used as a look up to identify missing data, I'm looking to automate the following:
•Open Excel file and refresh data
•save a copy as a csv file

I've been playing with using a windows batch command to open the file (so I can then use this .bat file in an Informatica Workflow). I've then set the data connections to refresh on open, but now struggling with saving to a CSV file. Have been playing with some VBA examples but haven't been able to get anything to work so far - I'm new to VBA and most of the examples i've found have extra bits in them for displaying messages and checking for existing files, but i dont the code well enough to be able to pick these lines out.

Looking for some advise firstly on whether what i'm trying is a viable approach, and then if it is what do I need to do differently (paticularly with the VBA). If it's not a good approach, then what should i consider?

thanks in advance!

posted Jan 6, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Try to programmatically extract data out of a pivot table - SSIS/Informatica is going to do a better job at it anyway

answer Jan 9, 2015 by Shweta Singh
Similar Questions
+1 vote

Could you please send any one call flow/concept of eDRX and power saving mode from mme /epc perspective?

0 votes

what is difference between power saving mode and eDRX ?

0 votes

Can anyone describe the use for a pivot table in Excel?