the Endeavor site has a support site that requires a login and ID. I would
suggest starting there or better, calling their tech support and seeing if
the program supports OLE Automation (similar in function to DDE but a newer
technology). I did see some indication at other sites that they are
interfacing with Voyager, so there must be a provision for this in their
software. Whether they encourage it or not or provide support for it in
terms of documentation, I can't say.

--
Regards,
Tom Ogilvy


" wrote:

Tom Ogilvy wrote:
Yes, it is often curious why people seem to want to be mysterious or vague.

"I have a specific application which will remain unnamed . . . " <g

:)

The other programs are library catalog client programs (not the actual
library catalog program itself), one is used for acquisitions, ordering
and paying for books and journals, the other is used for cataloging,
adding the information for books and journals, like the journal name,
publisher, call number and so on.

The products are from a company called Endeavor and the library catalog
product is called Voyager.

I haven't worked much with Visual Basic since version 3 or Excel much,
and so I'm not sure what the questions are that I should be asking :)

The following is some additional information if it helps make what I'm
trying to do more evident. My plan now is to check the references
mentioned in an earlier note (thanks!) and I'm checking about sending a
note to customer support for the programs. Does it seem that if a
program has the following classes defined that they are probably
documented for customers?

In Excel from the Visual Basic editor, then click Tools + References, I
cannot uncheck Visual Basic for Applications or Microsoft Excel 10.0
Object Library. In addition to those I'm checking one called
Acquisitions (I think that's the Voyager Acquisitions client).

Then when I go to the Object Browser I see the classes

<globals
clsAcqInCat
clsClaimedItem
clsCommunication
clsMarkedItem
clsReceiptHist

When I click clsCommunication I see the members list

BroadcastInvoiceLineItemChange
BroadcastLineItemChange
BroadcastVendorChange
LineItemCollection
LineItemID
VendorCode
and so on

My most advanced work with Excel was translating a VB 2.0 project that
worked with an earlier library catalog to a macro in Excel that worked
with the same catalog using DDE. So I'm wondering where do I start the
interaction between Excel and the other programs. I'm sure the
references will help me to get started.

Any recommendations about whether I should try the same from Visual
Basic instead of from Excel?

Have a nice day
John Paul Fullerton