Importing external data
 

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

Importing external data
 

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

Glen

"Glen Mettler" wrote in message
...
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

Importing external data
 

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.

--
Don Guillett
SalesAid Software

"Glen Mettler" wrote in message
...
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