PC Review


Reply
Thread Tools Rate Thread

Automate MS-Access from MS-Excel

 
 
=?Utf-8?B?WFA=?=
Guest
Posts: n/a
 
      20th Aug 2007
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate Access from Excel to run hidden =?Utf-8?B?WFA=?= Microsoft Excel Programming 0 21st Aug 2007 06:28 PM
Automate Excel from Access =?Utf-8?B?RGFsZSBGeWU=?= Microsoft Access Form Coding 0 28th Feb 2006 02:05 PM
MsgBox in Access Automate Excel =?Utf-8?B?UGljb3MgQXV0b20=?= Microsoft Excel Programming 0 4th Aug 2005 03:54 AM
Automate Access from Excel =?Utf-8?B?RXJuc3QgR3Vja2Vs?= Microsoft Excel Programming 1 16th Apr 2005 09:24 PM
Automate Access Via Excel VBA GarethG Microsoft Excel Worksheet Functions 0 17th Sep 2003 09:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:19 AM.