Stop relying on manual clicks and clunky code—let Excel refresh your queries automatically.

Is there a programatic way to set up references to needed type libraries in an Excel VBA macro?<P>Maybe I should explain why I want to do this. I'll be distributing the macro to a number of people.

Hello,<BR>Is there a way to set to Regional Settings of Windows in VBA-code? I wrote an application for users with different Regional Settings which is a bit annoying, so I want to Set the date and ...