Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Runnning Macros

Status
Not open for further replies.

AgentM

MIS
Jun 6, 2001
387
US
Hi

Can I run a MS Acees '97 macro thru Visual Basic?

Any help highly appreciated.

Rosh
 
Yes, there is a way......

follow the steps:

Public msaccess As access.Application

Private Sub Command1_Click()

Set msaccess = New access.Application

access.OpenCurrentDatabase ("DATABASE PATH"))
msaccess.DoCmd.RunMacro ("MACRO NAME")
msaccess.Quit

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top