DataImport External Data.............see options for obtaining data.

After data has been downloaded...........DataRefresh Data


Gord Dibben MS Excel MVP

On Thu, 27 Dec 2007 13:16:01 -0800, Jose Ruben Gonzalez-Baird
m wrote:

I was looking for an "External Data" Add-in from the list of available
add-ins, and didn't see one. Does this mean that the external data commonds
are available to all Excel versions 2000 and higher? If so, this would
eliminate the need to load any kind of add-in upon file start-up. Thanks, J
Ruben

"Jose Ruben Gonzalez-Baird" wrote:

I want to create some kind of macro to load a custom toolbar that I've
created, so that when any other user opens the file from any other location
on our network, the toolbar will load. The custom toolbar is really just
using the Refresh data commands common to the External Data toolbar.

Is there a simple way of doing this that won't require extensive coding?
Would each user need to have an External Data add-in installed on their
machine? Would it be possible for the macro to check to see if the external
data add-in is installed, and if it wasn't, then install, and then load the
custom toolbar?

Thanks for any and all responses. J Ruben