Jun 25, 2001 #1 AgentM MIS Jun 6, 2001 387 US Hi Can I run a MS Acees '97 macro thru Visual Basic? Any help highly appreciated. Rosh
Jul 31, 2001 #2 Guest_imported New member Jan 1, 1970 0 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 Upvote 0 Downvote
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
Jul 31, 2001 Thread starter #3 AgentM MIS Jun 6, 2001 387 US Thank you. I got it to work Upvote 0 Downvote