vba or macro to access

T

tlclear

have an add-in in excel. it is a mileage add-in. enter origin and destination
points (either by city/st, or zip code) and the add-in returns the mileage
between the points. However, it is a manual process and slow if doing more
than a few points.
Is there a way to grab the code that excel is using and bring it into access?
 
L

Larry Linson

tlclear said:
have an add-in in excel. it is a mileage add-in. enter
origin and destination points (either by city/st, or zip
code) and the add-in returns the mileage between the
points. However, it is a manual process and slow if
doing more than a few points. Is there a way to grab
the code that excel is using and bring it into access?
Click to expand...

My guess is that you have to be using some external procedure to obtain the
location of the origina and destination... name of city or zip code will not
provide you a location.

If it is VBA code, and does not refer to the Excel object model, it can be
used in Access. Highlight the code, Ctrl + C, move to the Access module, and
Ctrl + V. (And, if it does refer to the Excel object model, you may be able
to adapt it with minor changes.) As noted in the first paragraph, you may
need to check References in the Excel code and set a reference (or
include/load) external DLLs or other executables.

Larry Linson
Microsoft Office Access MVP
 
Top