Hi,

I posted this question in the word group 2 days back but......

Just curious about the differences in the common features of Word and Excel.
Here I go.

Why is word VBE a little different to Excel VBE? In excel if I have VBE open
and if i close all the excel normal windows then VBE will also close down.
But in Word If I have VBE open and close all the documents, VBE still
remains open. Is this difference somehow related to the products being
different (number crunching vs word processing). If so what exactly is there
within Word processing that MS has made VBE available even when Word
document is not open.

Why is it that Undo stack empties out on pressing save while in word it is
still available.

Thanks a lot,
Hari
India

Just a shot in the dark , but it may be because Word also opens an
associated template ( .dot) file, keeping the Word application open. How
this will work in Excel, I don't know. It's enough that you have uncovered
the differences - just use them and you'll be fine. There are so many of
these "why?" questions that have as their only answer "Because that's the
way they made it work!" If you try to understand MS too deeply, you'll go
insane and become a programmer! <g

Ed

"Hari Prasadh" wrote in message
...
Hi,

I posted this question in the word group 2 days back but......

Just curious about the differences in the common features of Word and
Excel.
Here I go.

Why is word VBE a little different to Excel VBE? In excel if I have VBE
open
and if i close all the excel normal windows then VBE will also close down.
But in Word If I have VBE open and close all the documents, VBE still
remains open. Is this difference somehow related to the products being
different (number crunching vs word processing). If so what exactly is
there
within Word processing that MS has made VBE available even when Word
document is not open.

Why is it that Undo stack empties out on pressing save while in word it is
still available.

Thanks a lot,
Hari
India

In excel if I have VBE open
and if i close all the excel normal windows then VBE will also close down.

I can't reproduce that behavior. (unless you mean close Excel and in word
the VBE closes as well when I close word).

--
Regards,
Tom Ogilvy



"Hari Prasadh" wrote in message
...
Hi,

I posted this question in the word group 2 days back but......

Just curious about the differences in the common features of Word and
Excel.
Here I go.

Why is word VBE a little different to Excel VBE? In excel if I have VBE
open
and if i close all the excel normal windows then VBE will also close down.
But in Word If I have VBE open and close all the documents, VBE still
remains open. Is this difference somehow related to the products being
different (number crunching vs word processing). If so what exactly is
there
within Word processing that MS has made VBE available even when Word
document is not open.

Why is it that Undo stack empties out on pressing save while in word it is
still available.

Thanks a lot,
Hari
India

Hi Tom,

Im sorry, not able to understand you.
I followed this procedu

a) Excel - Open a new session by typing Excel in run. Then I press Alt + F11
when Excel normal windows opens up. I go back to excel normal window and
click on the close button. VBE also closes down.

b) Word - Open a new session by typing Winword in run. Then I press Alt +
F11 when Word normal windows opens up. I go back to Word normal window and
click on the close button. VBE remains open.

(It could be possible that I might have some setting differences between the
2 programs which may be causing the above difference in behaviour.)

Thanks a lot,
Hari
India

"Tom Ogilvy" wrote in message
...
In excel if I have VBE open
and if i close all the excel normal windows then VBE will also close down.

I can't reproduce that behavior. (unless you mean close Excel and in word
the VBE closes as well when I close word).

--
Regards,
Tom Ogilvy



"Hari Prasadh" wrote in message
...
Hi,

I posted this question in the word group 2 days back but......

Just curious about the differences in the common features of Word and
Excel.
Here I go.

Why is word VBE a little different to Excel VBE? In excel if I have VBE
open
and if i close all the excel normal windows then VBE will also close
down.
But in Word If I have VBE open and close all the documents, VBE still
remains open. Is this difference somehow related to the products being
different (number crunching vs word processing). If so what exactly is
there
within Word processing that MS has made VBE available even when Word
document is not open.

Why is it that Undo stack empties out on pressing save while in word it
is
still available.

Thanks a lot,
Hari
India

VBE closes down in both cases for me. I don't use the VBE much in Word, but
I never remember it staying open in 97, 2000 or 2002 when I have closed
word on many different computers.

--
Regards,
Tom Ogilvy

"Hari Prasadh" wrote in message
...
Hi Tom,

Im sorry, not able to understand you.
I followed this procedu

a) Excel - Open a new session by typing Excel in run. Then I press Alt +
F11
when Excel normal windows opens up. I go back to excel normal window and
click on the close button. VBE also closes down.

b) Word - Open a new session by typing Winword in run. Then I press Alt +
F11 when Word normal windows opens up. I go back to Word normal window and
click on the close button. VBE remains open.

(It could be possible that I might have some setting differences between
the
2 programs which may be causing the above difference in behaviour.)

Thanks a lot,
Hari
India

"Tom Ogilvy" wrote in message
...
In excel if I have VBE open
and if i close all the excel normal windows then VBE will also close
down.

I can't reproduce that behavior. (unless you mean close Excel and in
word
the VBE closes as well when I close word).

--
Regards,
Tom Ogilvy



"Hari Prasadh" wrote in message
...
Hi,

I posted this question in the word group 2 days back but......

Just curious about the differences in the common features of Word and
Excel.
Here I go.

Why is word VBE a little different to Excel VBE? In excel if I have VBE
open
and if i close all the excel normal windows then VBE will also close
down.
But in Word If I have VBE open and close all the documents, VBE still
remains open. Is this difference somehow related to the products being
different (number crunching vs word processing). If so what exactly is
there
within Word processing that MS has made VBE available even when Word
document is not open.

Why is it that Undo stack empties out on pressing save while in word it
is
still available.

Thanks a lot,
Hari
India

Hi Tom,

I have 2002.
I just tried the same thing on my colleague's computer (2003) and word VBE
remains open.

Just for.. When i posted it to Word group previously, i got the reply from
Charles Kenyon
In Word, normal.dot and its modules are still available even when all
documents are closed. I don't know if that is the difference.

Only problem was, I wanted to know (just curiosity) why Word designed with
such a difference, but didnt get a response to the same.

Oh.. yes, also why does Excel doesnt offer Undo feature once document is
saved, while Word does.

Thanks a lot,
Hari
India

"Tom Ogilvy" wrote in message
...
VBE closes down in both cases for me. I don't use the VBE much in Word,
but
I never remember it staying open in 97, 2000 or 2002 when I have closed
word on many different computers.

--
Regards,
Tom Ogilvy

The issue revolves around outlook. If word is your outlook editor then the
VBE for word will remian open even if you close word, assuming that Outlook
is open. Close outlook and now try closing word with the VBE open and the VBE
will close also. Outlook is using the normal.dot

HTH

"Hari Prasadh" wrote:

Hi Tom,

I have 2002.
I just tried the same thing on my colleague's computer (2003) and word VBE
remains open.

Just for.. When i posted it to Word group previously, i got the reply from
Charles Kenyon
In Word, normal.dot and its modules are still available even when all
documents are closed. I don't know if that is the difference.

Only problem was, I wanted to know (just curiosity) why Word designed with
such a difference, but didnt get a response to the same.

Oh.. yes, also why does Excel doesnt offer Undo feature once document is
saved, while Word does.

Thanks a lot,
Hari
India

"Tom Ogilvy" wrote in message
...
VBE closes down in both cases for me. I don't use the VBE much in Word,
but
I never remember it staying open in 97, 2000 or 2002 when I have closed
word on many different computers.

--
Regards,
Tom Ogilvy

Hi Jim,

Thnx for that information. It behaves as u said.
In my office everybody has their Outlook open throughout the day (It's the
last application which is closed by us before pressing the "Turn off the
computer")
Hence, I wouldnt have been able to dream of this connection.

Thanks a lot,
Hari
India

"Jim Thomlinson" wrote in message
...
The issue revolves around outlook. If word is your outlook editor then the
VBE for word will remian open even if you close word, assuming that
Outlook
is open. Close outlook and now try closing word with the VBE open and the
VBE
will close also. Outlook is using the normal.dot

HTH

"Hari Prasadh" wrote:

You wanted to know about the stack. Word uses the stack fairly differently
because it is not trying to do calculations or other iterative tasks. This is
why work can allow for fast saves and do outo recovers if it crashes, as best
I can figure it... :)

HTH

"Hari Prasadh" wrote:

Hi Tom,

I have 2002.
I just tried the same thing on my colleague's computer (2003) and word VBE
remains open.

Just for.. When i posted it to Word group previously, i got the reply from
Charles Kenyon
In Word, normal.dot and its modules are still available even when all
documents are closed. I don't know if that is the difference.

Only problem was, I wanted to know (just curiosity) why Word designed with
such a difference, but didnt get a response to the same.

Oh.. yes, also why does Excel doesnt offer Undo feature once document is
saved, while Word does.

Thanks a lot,
Hari
India

"Tom Ogilvy" wrote in message
...
VBE closes down in both cases for me. I don't use the VBE much in Word,
but
I never remember it staying open in 97, 2000 or 2002 when I have closed
word on many different computers.

--
Regards,
Tom Ogilvy

Hari -

You have to realize that the two applications are designed by different
product teams. The Office product family is intended to present a
uniform interface across the board, but differences in the usage and
underlying architecture of the different programs led to different
design decisions along the way.

Jeeps and PT Cruisers are made by the same company, but there are
differences between them you wouldn't have expected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Hari Prasadh wrote:

Hi,

I posted this question in the word group 2 days back but......

Just curious about the differences in the common features of Word and Excel.
Here I go.

Why is word VBE a little different to Excel VBE? In excel if I have VBE open
and if i close all the excel normal windows then VBE will also close down.
But in Word If I have VBE open and close all the documents, VBE still
remains open. Is this difference somehow related to the products being
different (number crunching vs word processing). If so what exactly is there
within Word processing that MS has made VBE available even when Word
document is not open.

Why is it that Undo stack empties out on pressing save while in word it is
still available.

Thanks a lot,
Hari
India