View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nancy at AD STD Nancy at AD STD is offline
external usenet poster
 
Posts: 1
Default How to bypass startup form of access db via visual basic app/XL

I am creating a macro that opens an access database and updates some
information. My problem is that there is a lengthy startup form/process that
I want to bypass. Right now I am using

app.OpenCurrentDatabase "location_of_database"

as the vb programming statement to open the database. I know you can bypass
the startup if you manually open the database by pressing the Shift key, but
I do not know how to program this via visual basic within an excel macro.