LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I run a VBA procedure in Access from a LabView program? Thanks a lot for any help! Elvis Poprzenovic

Please tell me how to execute a VBA (Visual Basic for Applications)procedure in Microsoft Access database from a LabView 7.0 program.
0 Kudos
Message 1 of 2
(2,482 Views)
Hi Elvis,

Are you referring to executing a stored procedure in Access from LabVIEW? If so, we have examples that do this. Here's a Link. If you're looking at calling something else, or if the above solution doesn't work, another (more tedious) solution would be to create a macro in Access to call that procedure. Then, in LabVIEW, you can call that macro using ActiveX and the RunMacro procedure. For more information on ActiveX methods in Access, I would refer to the msdn website. Hope this helps!

Jeremy L.
National Instruments
Jeremy L.
National Instruments
0 Kudos
Message 2 of 2
(2,483 Views)