Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

VBA Macro Excel 2007 and Refresh All External Data and Save

Avatar of mjfigur
mjfigur asked on
Visual Basic ClassicMicrosoft ExcelVB Script
1 Comment1 Solution1307 ViewsLast Modified:
I am very new to working with coding VBA and have spent the last few hours trying to achieve exactly what I need.

Basically have an excel file with three workbooks (all pivot tables) and linked to an Oracle Database. I have already scheduled the automation on the Oracle side but need to have some way of automating the refresh all of the data by opening excel.

I have read that there is an open worksheet function that will run the code every time it is opened, however that will not work exactly right as I want the refresh to only occur if windows task scheduler is the one that opens the file. (That way the refresh will not be seen by end users whom are using the reports) Once the refresh is complete just need to be able to direct it to a place to save and possibly zip.

Thanks for your help in advance.
Avatar of VipulKadia
VipulKadiaFlag of India image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answers