Access 2000 or Excel 2000 & ActiveX

[chrisjames]

Will the ActiveX api for desktop work with Microsoft Access and or Microsoft Excel to bring data into them and then also be able to manipulate that data.

[JayF]

chrisjames,

As far as I know, this will work fine. Keep in mind that the Desktop API uses ActiveX to interface with eSignal, so you will need to be fluent in using a language that can utilize ActiveX (i.e. Visual Basic). Please feel free to review the documentation and examples at this File Share site.

[chrisjames]

Excel and Access Using API Desktop

Hi JayF & Co.,

Great, so this is what we would like to do in Excel now that we know it will work with the desktop API...

Right now we are pulling in quotes using DDE form eSignal which work fine for flat quotes, etc... but at the SAME time we would like to pull in about 20 or so quotes using VB inside Excel and the ActiveX and also place them onto the spreadsheet at the same time so we can fire events on that data...

With dde you are very limited WITH events and such.

So, at the same time we are using the DDE with Excel and pulling quotes into Excel using the API and VB we also want to be saving raw data to Access Database Tables (or SQL Server) using the API as the pull code...

so there should not be problem to do all three of these at once should there... i know its a little computer intensive but the computer will be dedicated to this one app alone

please advise...

Chris James