Hi,

I have a couple of quaestions...

1. Which of these two events occurs first when an excel workbook is opened?
2. Does this also depend on whether the Excel application (not the
particular workbook) is already open?

I'm asking these questions in regard to scheduling the macro for a later
time...

Any help would be greatly appreciated

Thanks,
--
Baapi

workbook_open first

makes no difference whether Excel started or not, it only makes a difference
if opening the workbook from code, then auto_open doesn't fire.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Baapi" <(E-Mail Removed)> wrote in message
news:01D99ECE-8AEE-41E6-B0DC-(E-Mail Removed)...
> Hi,
>
> I have a couple of quaestions...
>
> 1. Which of these two events occurs first when an excel workbook is
opened?
> 2. Does this also depend on whether the Excel application (not the
> particular workbook) is already open?
>
> I'm asking these questions in regard to scheduling the macro for a later
> time...
>
> Any help would be greatly appreciated
>
> Thanks,
> --
> Baapi

A quick test with a MsgBox function in each procedure shows that the
Workbook_Open fires first, regardless of whether the Excel application is
already running.

Note that before either runs you will likely get the 'Ok to run macros'
dialog.

Cheers,
Dave

"Baapi" wrote:

> Hi,
>
> I have a couple of quaestions...
>
> 1. Which of these two events occurs first when an excel workbook is opened?
> 2. Does this also depend on whether the Excel application (not the
> particular workbook) is already open?
>
> I'm asking these questions in regard to scheduling the macro for a later
> time...
>
> Any help would be greatly appreciated
>
> Thanks,
> --
> Baapi