Excel - Access
 

Hello,

I recently installed Office 2003. 2003 appears to have
additional security than the 2000 version I was previously
using.
I have macros in Excel -- that run macros, export tables
and queries and open forms from Access databases in Excel.
Why does the start up window for my access databases seem
to open when I run these macros using office 2003? Is
there an option that I have selected now that I did not
then? I used to be able to run my Excel macros pulling or
pushing things to Access without having to view/open
MSAccess.

Excel - Access
 

wrote in message ...
Hello,

I recently installed Office 2003. 2003 appears to have
additional security than the 2000 version I was previously
using.
I have macros in Excel -- that run macros, export tables
and queries and open forms from Access databases in Excel.
Why does the start up window for my access databases seem
to open when I run these macros using office 2003? Is
there an option that I have selected now that I did not
then? I used to be able to run my Excel macros pulling or
pushing things to Access without having to view/open
MSAccess.

You can use ADO to 'pull' and 'push' data from your Jet database
without having to automate the MS Access application, open forms, etc.

--