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!