View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default Difference between Word and Excel

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