Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Auto_open OR Workbook_open

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,726
Default Auto_open OR Workbook_open

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" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Auto_open OR Workbook_open

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto_Open Workbook_Open [email protected] Excel Programming 4 November 2nd 05 09:20 PM
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star Paul Moles Excel Programming 0 October 28th 04 03:53 PM
Auto_Open and Workbook_Open Erich Neuwirth Excel Programming 1 July 14th 04 01:19 AM
Auto_Open and Workbook_Open in Addins Erich Neuwirth Excel Programming 1 July 11th 04 06:54 PM
Auto_Open Vs Workbook_open Soniya Excel Programming 2 September 23rd 03 03:56 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"