Are two Saves the same?

[Guest]

Hi all,

In Excel window, there is a save and in VBE , there is also a save, are they
same or not? What is the difference?

Clara

thank you so much for your help

 

[Jim Rech]

They are the same. Just a convenience to be working in the VBE and be able
to save the workbook without switching back to Excel.

--
Jim
| Hi all,
|
| In Excel window, there is a save and in VBE , there is also a save, are
they
| same or not? What is the difference?
|
| Clara
|
| thank you so much for your help

 

[Guest]

The action they perform is the same. The save in Excel saves the
ActiveWorkbook.

The save in the VBE saves the workbook associated with the ActiveProject
(the project with the highlight in the project explorer). These may be two
different workbooks. As long as you pay attention, it should work.

You can see this by looking at File=>Save in the VBE to see what would be
saved.

 

[Dave Peterson]

On top of what Jim and Tom have written, there have been a few posts that saving
in the VBE doesn't work correctly.

I've never had any problem in any version of excel that I've used (xl97-xl2003).

But there have been some posts from some very smart people who never use the VBE
save icon. They'll go through excel or use code.

 

[Guest]

Maybe because they didn't differentiate the Active Project from the Active
Workbook

Being very smart does not always mean being very astute.

Seems to me I haven't been very astute whenever I had a problem or I assumed
something that wasn't true. I make no claim to being very smart, so my
experience may not be applicable.

 

[Guest]

Not a difference but rather a feature is that in certain circumstances I have
disabled the save functionality (by removing the Toolbars and Ctrl + S) in
the spreadsheet itself (where I have used Excel purely as an interaface into
a database of some sort). In this case I save the spreadsheet by using the
Save button in the VBE.

 

[Jim Rech]

Maybe because they didn't differentiate the Active Project from the Active
After the first couple of dozen times I made that mistake I learned to check
that I have the right project active. Most of the times that I use Save in
the VBE it is to save a change to an add-in. Pretty convenience to be able
to do that.

--
Jim
| Maybe because they didn't differentiate the Active Project from the Active
| Workbook
|
| Being very smart does not always mean being very astute.
|
| Seems to me I haven't been very astute whenever I had a problem or I
assumed
| something that wasn't true. I make no claim to being very smart, so my
| experience may not be applicable.
|
| --
| Regards,
| Tom Ogilvy
|
|
| "Dave Peterson" wrote:
|
| > On top of what Jim and Tom have written, there have been a few posts
that saving
| > in the VBE doesn't work correctly.
| >
| > I've never had any problem in any version of excel that I've used
(xl97-xl2003).
| >
| > But there have been some posts from some very smart people who never use
the VBE
| > save icon. They'll go through excel or use code.
| >
| >
| >
| > clara wrote:
| > >
| > > Hi all,
| > >
| > > In Excel window, there is a save and in VBE , there is also a save,
are they
| > > same or not? What is the difference?
| > >
| > > Clara
| > >
| > > thank you so much for your help
| >
| > --
| >
| > Dave Peterson
| >

 

[Dave Peterson]

IIRC, the problem reared its head when the unknown perpetrator, er, smart
person, was working with an addin.

And there were followups in that thread (whereever it was) that made the same
points as you and Tom did. He responded that wasn't the problem.

And even though I respect that person, I haven't stopped using the icon (since
I've never had trouble with it).

And I know when I read either your posts or Tom's, I know I can trust
them--since they were written by very smart (at least excel smart <vbg>) people.

 

[Guest]

I have to admit that since I am a big user of the immediate window (always
have it open), I usually just do
workbooks("myaddin.xla").Save <cr>

 

[Guest]

<FWIW> Just to add to what's already been stated by the others, ..I have
gotten into the habit of waiting until the Save icon's tooltip displays the
project name.

 

[Dave Peterson]

That seems like a pretty smart thing to do.

<it's Friday!>