How do I run a macro from VB

[jjjjjjj]

Hi, I have created a macro in Access 97 which deletes records from the tables in my database and imports delimited text files. When I run the macro in Access everything works fine. However, I have been unsucessfull at creating an application to run the macro. Does anyone have any ideas on how I can do this? I have been trying to use DoCmd.RunMacro but it has not been working. It opens my database but just hangs there.

 

[skfoster]

Why not to convert from macro to vb?

 

[jcurtis]

I thought that it may be easier to just run the macro that was already created in Access.

 

[jjjjjjj]

I thought that it may be easier to just run the macro that was already created in Access.

 

[huzza]

Try getting the application to run the command line
dbpath\myDb.mdb /x macroname
this is a standard access command line option that allows you to open your database and run any macro within it (effectively turning the macro into an autoexec macro on this loading of the db).
If you need any further details on it you can find it in access help under command-line options
I hope this helps,
Richard