View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moon[_5_] moon[_5_] is offline
external usenet poster
 
Posts: 40
Default How to bypass startup form of access db via visual basic app/XL


Try: Application.EnableEvents = False



"Nancy at AD STD" <Nancy at AD schreef in
bericht ...
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.