Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > VBS Script to R...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 30586 of 31576
Post > Topic >>

VBS Script to Run Macro in Access 2003

by White Horse <michael_13143@[EMAIL PROTECTED] > Jun 26, 2008 at 06:23 AM

I want to nightly run a VBS Script in Scheduled tasks to open an
Access 2003 database and execute a macro.

The problem is that the database opens to a switchboard screen.  I
need to open this database with a VBS script that mimicks opening the
database with {****ft} open.  My code:


dim accessApp
set accessApp = CreateObject("Access.Application")
accessApp.visible = True
accessApp.OpenCurrentDataBase("C:\ACF\Copied from Server\ACF.mdb")
accessApp.Run "Macro1"
accessApp.Quit


When this script executes, the switchboard is open, and the Macro1
can't be found (executed).


Thanks
 




 4 Posts in Topic:
VBS Script to Run Macro in Access 2003
White Horse <michael_1  2008-06-26 06:23:58 
Re: VBS Script to Run Macro in Access 2003
"JvC" <johnv  2008-06-26 06:54:32 
Re: VBS Script to Run Macro in Access 2003
"Albert D. Kallal&qu  2008-06-26 15:17:24 
Re: VBS Script to Run Macro in Access 2003
White Horse <michael_1  2008-06-26 09:36:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:05:19 CST 2008.