Auto execute macro when database opened

Cam

Guest

Posts: n/a

27th Jul 2009

Hello,

I have a macro to obtain data through several append queries. Upon openning
the database, it runs the macro. In order the run the macro on the weekend, I
setup a task scheduler in Windows XP to run unattended. But the problem is
everytime the database is opened, it requires users to click a pop up asking
to open the file (must be security within Access).

What can I do to bypass the pop up so it can open the database and run the
macro automatically on the weekend? Thanks

« Digital Signature Problem | Disable copying a database »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Execute Macro	dennis	Microsoft Excel Programming	4	17th Jan 2009 04:47 PM
Auto Execute Macro	dennis	Microsoft Excel Misc	4	17th Jan 2009 04:47 PM
Auto Execute Macro	dennis	Microsoft Excel Worksheet Functions	4	17th Jan 2009 04:47 PM
How to get a macro to execute for every xls thats opened on a mach	=?Utf-8?B?am9obiBjb253ZWxs?=	Microsoft Excel Programming	2	23rd Jun 2006 07:56 AM
Execute a macro after excel has been opened?	Kenneth	Microsoft Excel Worksheet Functions	5	14th Dec 2003 01:34 AM