Help- Calling an ILX Excel function in Access

G

Guest

I am trying to call an ILX function (i.e. =ILX|Q!'ONFD-GA,BID') in an Access
Form. In Excel, this function pulls live data from a financial server
(Thompson TradeWeb) and gives the current quote. I am attempting to move
information to Access and was wondering if it is possible to pull live data
in a database. If it is possible, will the link update as the data changes?
From reading other questions in this forum, it sounds like the best way of
doing this would be to call an Excel function. My VB skills are lacking, so
any help would be greatly appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Live Data in Access 3
calling function without wait 8
calling function in another DB 5
Using excel add-ins in access 1
Alternative for MS Excel VLOOKUP function in MS Access 2003 2
Calling Module function in query 4
Reference to object calling a function... 3
excel function in access 4

Top