Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate MS-Access from MS-Excel XP Excel Programming 0 August 20th 07 05:44 PM
Automate Excel upload into static Access Table Seanarthur Excel Programming 3 March 8th 06 01:33 AM
MsgBox in Access Automate Excel Picos Autom Excel Programming 0 August 4th 05 03:54 AM
Automate Access from Excel Ernst Guckel[_4_] Excel Programming 1 April 16th 05 09:24 PM
Automate Access hlam Excel Programming 10 November 16th 03 05:42 AM


All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"