Thread
:
How to bypass startup form of access db via visual basic app/XL
View Single Post
#
2
Posted to microsoft.public.excel.programming
moon[_5_]
external usenet poster
Posts: 40
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.
Reply With Quote
moon[_5_]
View Public Profile
Find all posts by moon[_5_]