Hidden macro from batch script

[Kempes]

Hi all,

I currently have a batch script that opens an access 97 db, runs a macro, then closes.

The user currently sees the app open up and close.

Is there a way to hide the access application when running the batch script?

Many thanks
Kempes

 

[boblarson]

Nope, but you might be able to use APP.MINIMIZE before running your other macro upon opening so that it doesn't stay up on screen.

 

[Kempes]

Thanks for the reply.

found this elsewhere which seems to work. It means I no longer need a batch script. Running directly from excel (forget to mention I was also tying excel into this).

DatabaseName$ = "dbpath"
Set acapp = CreateObject("Access.Application")
acapp.Visible = False
acapp.OpenCurrentDatabase (DatabaseName$)
acapp.DoCmd.RunMacro "macroname"
acapp.closecurrentdatabase

However, I have just thought of another issue. Potentially, Users may not have acc 97 installed. May have to rethink this one.