View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default 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.