Display across different computers

[Hari Prasadh]

Hi,

I have a SET of presentations which are being developed in 2002 using VBA.
Nothing fancy, just the normal Excel OLE charts/worksheets , Graph applets
and textboxes.

The people who will be perusing these PPt's might use any of Office 2000 or
2002 (and compatible windows)

I wanted to know if I should be AWARE of any issues for the folks who will
be making use of these PPT's. Like would it look different on their
computers, font etc muddles up etc. (am using Arial throughput)

One issue (though occurring across many computers) is that I stick an excel
worksheet OLE with normal borders and background pattern , but PPT displays
(normal view) bold borders for some cells while thin borders for others.

Again I experience the above problem in slide show mode while normal view
is fine.

Hence, wanted to be aware of similar issues (visit a PPT bug so that i may
tell the concerned people?)

Thanks a lot,
Hari
India

 

[Guest]

You mentioned the Excel spreadsheets. If it's purely for demonstration, or
presentation purposes, would it be appropriat to include a screenshot, of the
spreadsheet,
or
will it be used interactively, eg. the data will be changed during
presentation?

Daniel

 

[Brian Reilly, MS MVP]

Hi Hari,

Here are two things to watch out for:
1. Any VBA objects that are new in PPT 2003 will not compile in PPT
2000 when that module is run (it compiles the modules when some code
in that module is trying to run. So, you have to have an If Then Else
statement in the main module that tests for Version and if it is 2003
then you need to call another module containing that 2003 object code.

2. The borders are showing up at different thicknesses because you do
not have the embedded XL object scaled to 100% x 100%. If you need
precise positioning in PPT, the best way to do this is to draw a test
rectangle in PPT using an AutoShape and copying and pasting it into
the XL worksheet range you are embedding (Make it highly transparent
in PPT first) so you can see through it. Now resize your range to fit
that rectangle.

And when you paste it into PPT, resize it to 100% x 100% and then
position the top and left.

Good luck,
Brian Reilly, MVP

 

[Steve Rindsberg]

One issue (though occurring across many computers) is that I stick an excel

worksheet OLE with normal borders and background pattern , but PPT displays
(normal view) bold borders for some cells while thin borders for others.

This can happen when any program is forced to display fairly detailed
information at relatively low resolution. To oversimplify, a line might fall
on one row of pixels exactly or it might straddle two rows, so it might display
twice as bold in the second case.

Sometimes shifting the graphic a little, changing its size or changing the line
thickness is enough to do the job.

 

[Hari Prasadh]

Hi Brian,

(Make it highly transparent in PPT first)

Great tip.

Thnx also for the If then else solution.

Thanks a lot,
Hari
India

 

[Hari Prasadh]

Hi Steve,

a line might fall on one row of pixels exactly or it might straddle two
rows, so it might display twice as bold in the second case.

A nice piece of logic.

Thanks a lot,
Hari
India