Excel connectivity.

[Julian Milano]

If I have a number of 3rd party products which I would like to send data to
from my XL application, what methods would I use?

I know each product is different, but if I could influence the author of
those products to add certain functionality so that I can use my XL app to
communicate data to these products, what method would be the best?

--

Julian Milano
|
(To reply, remove NOSPAM from the email address)
|

 

[Dave Peterson]

First thing I'd ask is if they can read an excel file directly--maybe even ask
if they can show a list of worksheets and prompt me for a range.

If that's too much, I'd ask if their programs can import .csv files.

Inside excel, you can save a single worksheet as a text file with each value
separated by a comma.

In fact, you may want to check if the programs already support this. Sometimes,
it's under File|import...

 

[Julian Milano]

Thanks Dave,

What about if the data exchange needs to be independant of human influence,
like, say, XL needs to push data to the 3rd party application on an hourly
basis?

--

Julian Milano
|
(To reply, remove NOSPAM from the email address)
|

 

[Dave Peterson]

Excel has an ontime feature that allows you to things every so often.

You can read more information at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm

But how that is implemented will depend on what you find out from your third
party developers.