RE: Is there a way to run a macro upon opening a document?

From: Beverly76 (Beverly76_at_discussions.microsoft.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 10:09:03 -0700

I'm not sure where to put this code to make it work. I tried Pasting it into
the macro (before and after my command lines). And I tried pasting it just
onto the VBA Editor. But when I opened the file, nothing happened.

"Mister T" wrote:

> Private Sub Workbook_Open()
>
> your code here
>
> End Sub
>
> "Beverly76" wrote:
>
> > I have a macro that I use to open a dbf file and saves it as and xls file
> > because for some reason Access has trouble opening it as a dbf (just this one
> > file-the others are o.k.) I would like the macro to run upon opening the
> > Excel document file without any other prompting because then I could automate
> > the action of opening the file through MS Access so that the user would not
> > have to pay too much attention to the process.
> >
> > Any ideas?
> >
> >
> > --
> > Sincerely,
> > Beverly76