Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Access form to assign values of variables in an Excel VBAprogram
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Access form to assign values of variables in an Excel VBAprogram
YOu need to do a search for ADO method (ActiveX Data Object). There are plenty of example of code on the web. You need to add two 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 a recordset. You can either use SQL to filter the recordset or scroll through the record set from first entry to last entry. There is very little differences between and Access table and an Excel shreadsheet. they both have the same file structure like all Microsoft Office products and the only difference is the Tool you use to open the file (Access or Excel). -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194580 http://www.thecodecage.com/forumz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I assign variables | Excel Programming | |||
how to access or copy excel form controls (eg. dropdownlist) values to a database | Excel Programming | |||
Using solver variables to access database values | Excel Programming | |||
Submitting form variables to Excel sheet | Excel Programming | |||
Assign a variables value to a TextBox | Excel Programming |