Using Access form to assign values of variables in an Excel VBAprogram
in [Programming]
|
From: joel on 10 Apr 2010 15:35 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/showthread.php?t=194580 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: JavaScript & WorkBook.PivotCaches Next: How do I change a mouse icon !!!!!!!!!! |