Importing external data

[Glen Mettler]

Using Excel 2002.

Is it possible to import data from another source (text or other excel)
without opening the other file?

Here is the situation. I have a workbook with several tabs. One of those
tabs contains program events and associated dates that are propigated
throught the other tabs. The workbook is distributed to several remote
locations for additional inputs. The event dates change which in turn
changes the dates in the associated tabs. For reasons I won't explain here,
it is not advisable to link the event dates from another file - everthing
needs to be selfcontained.

What I want to do is make a menu option "Update Events". The idea is that I
could send an update in text or Excel format with instructions to put the
file in the same directory as the workbook. The user would select Update
Events and using the standard getfile dialog box get the file and import the
data directly into the appropriate cells without opening the file or at
least transparent to the user. After the import, delete the file and notify
the user with a msgbox that the import is complete.

That gives me a way to update key data without having a link. Is that
possible?

Glen

 

[Glen Mettler]

Got the answer from Ron de Bruin's web site.

Glen

 

[Don Guillett]

Yes,

You can use a formula to get the data and then change to values so only the
info is left. You can design a macro to do this with one mouse click for the
whole thing. I just did the same thing for a client.