VBA Excel modification - PowerPivot and Pivot Tables


I got a couple of macros that works fine and now I wana mix them in only one.

Macro 1 opens all books in a directory and update every Pivot table.

Macro 2 does something similar, but it works with PowerPivot. It refresh the powerpivot data and after that it refresh the Pivot Tables in active Excel book.

Now I need you to mix both macros in one single one:

1 - We will place both macro in a new workbook, and it will run when workbook open. First you must confirm if the PowerPivot complement is active, if it is not, then active it (I do not have the code to active the complement).

2 - read a directory and open the xls files (I got this code in the first macro)

3 - for each workbook:

- if it has a PowerPivot source, then run the code in macro 2

- if not, then run the macro 1, this is refresh every pivot table in active workbook (this code is working fine now)

4 - save, close and open next (this code is in macro 1)

Both macros works fine separatedly, and combined they should not have any problem.

I can do some test, but I prefer you to have PowerPivot in your side to do some test before I received the first version...


Skills: Excel, Visual Basic

See more: powerpivot vba, vba powerpivot, powerpivot excel vba, excel vba powerpivot, refresh powerpivot data vba, powerpivot vba refresh, excel powerpivot vba, refresh powerpivot vba, powerpivot macro, vba workbook pivot tables, vba excel powerpivot refresh, macro powerpivot, open powerpivot refresh pivot vba, macros powerpivot, refresh powerpivot table vba, powerpivot macros, vba pivot table, powerpivot pivot table, powerpivot vba macro, vba powerpivot data, powerpivot vba update, powerpivot macro refresh data, excel vba refresh powerpivot, refresh pivot table vba powerpivot, vba powerpivot update

About the Employer:
( 67 reviews ) Silla, Spain

Project ID: #1274418

Awarded to:


Hello, my name is Fernando and I'm Excel/VBA programmer since 2003. Can I merge these macros in 2 or 3 hours at most. Please see my personal message for the justification of my bid. Thank you in advance and good luck w More

$40 USD in 1 day
(4 Reviews)

5 freelancers are bidding on average $54 for this job


I have 20 years Excel experience and strong VBA skills. Please check my feedback and 100% completion record.

$80 USD in 1 day
(11 Reviews)

I can provide the required macro within 2 days.

$30 USD in 2 days
(32 Reviews)

Hi, I am a computer science graduate and have enough skills in VBA for Excel, Access and Word. I am very interested in your project. I can develop this within a day.

$50 USD in 1 day
(10 Reviews)

Hi, I'm ready to start your work.

$70 USD in 3 days
(0 Reviews)