Using Access form to assign values of variables in an Excel VBAprogram

R

rjagathe

I have created a VBA program for Ms Excel.But,to get desired results,
every time, I go into the code to change the values of variables.Is
there a way to get the values of variables stored in an Access table?
 
J

joel

YOu need to do a search for ADO method (ActiveX Data Object). Ther
are plenty of example of code on the web. You need to add tw
references in your VBA to use the method.

from VBA menu tools - References


1) Microsoft Access XX.X object library
2) Microsfot ActiveX Data Objects X.X library

Use the latest versio of the two libraries on your PC.

You will make a connection to the Access file and then Open
recordset. You can either use SQL to filter the recordset or scrol
through the record set from first entry to last entry.


There is very little differences between and Access table and an Exce
shreadsheet. they both have the same file structure like all Microsof
Office products and the only difference is the Tool you use to open th
file (Access or Excel).
 
Top