Getting the current resolution with VBA?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Gilbert - 30 Sep 2007 01:57 GMT

Is there a way to get the value of the user's current resolution with
VBA? Maybe having it talk to AppleScript somehow?

I have an Add-in that does this in Windows using "user32" and "gdi32",
but I need to have it work on a Mac as well.

Reply to this Message

Jim Gordon MVP - 30 Sep 2007 18:14 GMT

Hi Alex,

The closest thing I could find is MsoScreenSize.

Will that do it for you?

-Jim

Quoting from "Alex Gilbert" <valueneutral@gmail.com>, in article
1191113839.624537.217360@50g2000hsm.googlegroups.com, on [DATE:

> Is there a way to get the value of the user's current resolution with
> VBA? Maybe having it talk to AppleScript somehow?
>
> I have an Add-in that does this in Windows using "user32" and "gdi32",
> but I need to have it work on a Mac as well.

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

peterthebag@yahoo.com - 05 Oct 2007 21:02 GMT

Hi,

You could use a unix utility called cscreen and an applescript.

you can get cscreen from

http://scriptbuilders.net/files/cscreen1.0.html

just install in in the usr/bin directory

this is normally an invisible directory, so you need to use a utility
like OnyX to show invisibles.
you can then use an applescript like this one to get the screen
resolution reported by cscreen.

do shell script "cscreen"
set ScreenRes to the result
display dialog ScreenRes

rather than using display dialog you could use the value returned as
an input for some other process - telling PPT which version of a
slideshow to show, for example.

Hope that helps.

Reply to this Message

Mac Forum / Applications / PowerPoint / October 2007

Getting the current resolution with VBA?