Excel connectivity.

J

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)
|
 
D

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...
 
J

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)
|
 
Top