How to run more than one Access macro in Vb 1

[nissan240zx]

Hello All,
I am running a access macro in my vb code.

'Macro start to do the import to the Raw table - Start
    txtStream.WriteLine "Thor Macro Start" & CStr(Now) & vbCrLf
    Dim accobj As Access.Application
    Set accobj = CreateObject("Access.Application")
    ' Set database path to web folder on IOSC Web
    accobj.OpenCurrentDatabase ("C:\ThorVivek\Backend.mdb")
    accobj.DoCmd.RunMacro ("Process")
    accobj.CloseCurrentDatabase
    Set accobj = Nothing
    txtStream.WriteLine "Thor Macro End" & CStr(Now) & vbCrLf
'Macro start to do the import to the Raw table - End

I want to run 3 macros similar to this in one code...
Please advice...
Thanks in advance...

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder

 

[HarleyQuinn]

If they're on the same DB you could just add them as extra lines under your current Macro calling code

accobj.DoCmd.RunMacro ("Process")
accobj.DoCmd.RunMacro ("YourMacroName1")
accobj.DoCmd.RunMacro ("YourMacroName2")

Would that work for your scenario?

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[nissan240zx]

Hey HarleyQuinn...you are right..all the macros are in the same db..
Thanks....Super

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.