Difference between Word and Excel

[Hari Prasadh]

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

 

[Ed]

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

 

[Tom Ogilvy]

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).

 

[Hari Prasadh]

Hi Tom,

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

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]

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.

 

[Hari Prasadh]

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

 

[Guest]

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

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

 

[Hari Prasadh]

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

 

[Guest]

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

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

 

[Jon Peltier]

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/
_______