Hello, I've used the XML dvper feature in excel to pull news articles from a website. Everything works however, I need this to be refreshed automatically from one period to another. This is super important. If i click table design refresh connection properties which i usually do, everything is grayed outÂ
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
XML Automatic refresh
0
Discussion
Is the problem that it won't refresh or that you want it to automatically refresh and so you're looking for guidance on the macro code to use for that? Also, editing your quesiton and uploading a sample file will help us help you)
don (rep: 1989) May 4, '20 at 3:01 am