Office XP?

21 views
Skip to first unread message

mates

unread,
Apr 12, 2001, 10:54:26 AM4/12/01
to
hello
does anyone have any programing experience with new Office XP and especially
in Excel XP?
Latest reviews don't say much about changes in VBA, object model, Forms, ...
is there something a serious developer should be aware of?
thanx
m.


Chip Pearson

unread,
Apr 12, 2001, 11:27:28 AM4/12/01
to
There are very few differences at all. The VBA language itself
is unchanged, and the Excel object model is the same. Nothing to
worry about.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"mates" <matej....@nospam-ibisco.si> wrote in message
news:#MZE8B2wAHA.632@tkmsftngp03...

John Walkenbach

unread,
Apr 12, 2001, 12:24:26 PM4/12/01
to
Most of your old code will work just fine in Excel 2002.

One thing to be aware of is a new setting called 'Trust access to Visual
Basic project.' This setting is turned off, by default. When it's turned
off, your VBA code cannot manipulate objects in the VB Project. In Excel
2002, the example at my web site won't work unless the user changes the
default setting:

http://j-walk.com/ss/excel/tips/tip76.htm

Also custom toolbars and toolbar customizations created in previous versions
are not migrated to Excel 2002. And if you happen to use Microsoft Map,
you'll find that it has been removed from Excel 2002.

You might want to take a look at MS's Knowledge Base:

http://search.support.microsoft.com/kb/

Do a search for Excel 2002, and check for what's new within the past 30
days.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss


"mates" <matej....@nospam-ibisco.si> wrote in message
news:#MZE8B2wAHA.632@tkmsftngp03...

Niek Otten

unread,
Apr 12, 2001, 2:15:24 PM4/12/01
to
I did notice that it calculates my sheets twice as fast. Very welcome; I
process batches of 60 sheets, 10 seconds calctime each.
However, I regret I have to agree with John (in another thread): not many
useful new features, no solutions for complaints that have been there for
many years.

Regards,

Niek Otten

"mates" <matej....@nospam-ibisco.si> wrote in message
news:#MZE8B2wAHA.632@tkmsftngp03...

Stephen Bullen

unread,
Apr 12, 2001, 4:35:17 PM4/12/01
to
Hi Mates,

> Latest reviews don't say much about changes in VBA, object model, Forms, ...
> is there something a serious developer should be aware of?

Contrary to Chip and John, I think there's actually quite a few minor, but
useful, changes to the Excel object model, particularly for the serious
developer, including:

The Application object getting hWnd and hDC values, to use in our API calls

CommandBar buttons now have a Picture property that can be set and read,
meaning the end of PasteFace and wiping the clipboard.

We can override the system default regional settings, for example to print
reports for different countries.

The formula auditing function is very useful when you're trying to work out
what a formula is doing (particularly if you're reviewing/redesigning somebody
else's worksheet!)

We can now completely prevent the ability for users to customize our
commandbars if we want to

We can password protect individual ranges within a sheet, and specify who
that protection applies to.

When protecting sheets, there is much more control of what can/can't be done
by the user in the sheet

The Function tooltips are extremely useful - when entering a function in the
worksheet, the parameters pop up, just like they do in the VBE.

When saving a workbook, we can choose which encryption algorithm to use, from
those available to windows, providing 'bullet-proof' workbook security

Individual workbooks can now be signed using a digital signature. If the
file is altered and saved, the signatures are removed. This provides an
excellent mechanism for 'approval' processes, as well as confirmation that
files we created haven't been tampered with since their creation. (In Excel
2000, you could do that to the VB projects. Excel 2002 applies the same
principle to the entire workbook).


Regards

Stephen Bullen
Microsoft MVP - Excel
http://www.BMSLtd.co.uk or http://208.49.24.208


Harald Staff

unread,
Apr 12, 2001, 6:10:38 PM4/12/01
to
Wow. Lots of pretty cool things :-)

What does "specify who that protection applies to" mean ? Can I lock it from
the four untrusted fools and let the rest have more freedom ?

Also, are there more events than before ?

Best wishes Harald


Stephen Bullen <Ste...@BMSLtd.ie> wrote in message
news:VA.0000082...@bmsltd.ie...

Jeff McAhren

unread,
Apr 12, 2001, 6:24:09 PM4/12/01
to
> We can password protect individual ranges within a sheet, and specify who
> that protection applies to.
>
> When protecting sheets, there is much more control of what can/can't be
done
> by the user in the sheet

What will happen when workbooks with advanced protection are opened in XL
97/2000? Is my assumption that the cells will be locked for all users
correct? If a wb created with XP is opened saved from 97/2000, will the
advanced protection (and/or other XP features) still be present when opened
back in XP, or will non-97/2000 functionality be gone?

Can anyone that has been using XP predict any dramatic/problematic issues
when moving a workbook from an XP machine back to a 97/2000 machine?

I'm would love to demo XP myself, but can't because I don't have a spare
machine, and can't risk tampering with my current machine at this time.
Hopefully I will have a chance to test XP soon, as I'm the guy at my company
who usually deals with MSOffice version migration issues.

Thanks,

--
Jeff McAhren
Dallas, Texas


"Stephen Bullen" <Ste...@BMSLtd.ie> wrote in message
news:VA.0000082...@bmsltd.ie...

Dana DeLouis

unread,
Apr 12, 2001, 8:12:39 PM4/12/01
to
I came across this today...

XL2002: Summary of Workbook and Worksheet Application Events
http://support.microsoft.com/support/kb/articles/Q291/2/94.ASP


"Harald Staff" <harald...@eunet.no> wrote in message
news:uatba05wAHA.2292@tkmsftngp02...


> Wow. Lots of pretty cool things :-)
>

<snip>

Tim Teichman

unread,
Apr 12, 2001, 10:33:52 PM4/12/01
to
If I have code in a spreadsheet that creates a customer toolbar, how does it
behave in 2002?

Tim

"John Walkenbach" <jo...@j-walk.com> wrote in message
...

Harald Staff

unread,
Apr 13, 2001, 4:35:05 AM4/13/01
to
Thanks Dana.

Best wishes Harald

Dana DeLouis <da...@email.msn.com> wrote in message
news:OIivG66wAHA.1392@tkmsftngp03...

Stephen Bullen

unread,
Apr 13, 2001, 6:20:52 AM4/13/01
to
Hi Jeff,

> What will happen when workbooks with advanced protection are opened in XL
> 97/2000? Is my assumption that the cells will be locked for all users
> correct?

Yes.

> If a wb created with XP is opened saved from 97/2000, will the
> advanced protection (and/or other XP features) still be present when opened
> back in XP, or will non-97/2000 functionality be gone?

I just tested this:
1. Started Excel 2002, set range A1:F15 of sheet1 to be editable by myself
without a password, and by everyone else with a password. Save and close the
file.

2. Started Excel 97, open the same file. All cells are locked and can't be
edited. Changed some stuff in Sheet2. Unprotected Sheet1, changed some
stuff, protected it again. Saved and closed the file

3. Opened it again in Excel 2002, and the protection that I set up in step 1
was still there and working.

Stephen Bullen

unread,
Apr 13, 2001, 6:20:47 AM4/13/01
to
Hi Harald,

> What does "specify who that protection applies to" mean ? Can I lock it from
> the four untrusted fools and let the rest have more freedom ?

Exactly that. I'm not sure if it requires specific a O/S though <g>.

Jeff McAhren

unread,
Apr 13, 2001, 10:20:32 AM4/13/01
to
Very cool. Thanks for the info.

--
Jeff McAhren
Dallas, Texas


"Stephen Bullen" <Ste...@BMSLtd.ie> wrote in message
news:VA.0000082...@bmsltd.ie...

Reply all
Reply to author
Forward
0 new messages