But that code gived a dialogbox that I need to press OK on, thats not a solution. This will be on a screen just like a viewer, so I would like to have it automatic.

I use xml-dataimport, and the "refresh every XX minutes" and all other options in the connection-settings is grayed out. So I cant use excels inbuilt feature for auto-update.

As intelligent excel is, and how much there can be done in it, it would supprice me much if it cant be done.