ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automate Access from Excel to run hidden (https://www.excelbanter.com/excel-programming/396030-automate-access-excel-run-hidden.html)

XP

Automate Access from Excel to run hidden
 
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.



All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com