Automate MS-Access from MS-Excel
Using Office 2003 and Windows XP;
I'm trying to automate Access from Excel, my code below so far:
Dim oAccessApp As Object
Set oAccessApp = GetObject(csFullName, "Access.Application")
oAccessApp.Visible = False
oAccessApp.Run "Form_Validate"
Set oAccessApp = Nothing
This runs okay, but as you will notice, I'm trying to run the App quietly -
thus Visible = False; however, the App opens visible and I have to enable
macros. Can someone alter my code or please post example new VBA that will
automate Access and run it hidden?
Thanks much in advance.
|