Hidden macro from batch script (1 Viewer)

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

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.

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.