Software

Ask something
Discussion Locked

Using Access object from Excel

0 helpful
3 replies

by johnfinlay

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an access database form that calls an excel workbook. The client then enters information that is calculated, with the result appearing in a particular cell. What I then need to do is have excel then call the access database(which is probably still open) and apply the contents of that cell onto a textbox on a form(which is probably still open). How can I refer to particular objects within a database from Excel???

3 replies

by glen_mcleod

Why don't you try it the other way, as you're already controlling Excel from Access. Once the user enters the data and returns, get the data through code in your Access app.

You know the address of the cell, so just read the data from there intoa local Access variable, then put it into your textbox.

Glen

This discussion is closed to new replies.