Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Configuration
Have a look at
http://support.microsoft.com/?id=148395 hope this helps Rowan "Dennis" wrote: How do I obtain the screen configuration of the system through codes of programming in Visual Basic? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Configuration
Rowan thank you;
But I need it to execute from Microsoft Excel through VBA. Really I ignore some commands from Microsoft Access. Do you help me? "Rowan" wrote: Have a look at http://support.microsoft.com/?id=148395 hope this helps Rowan "Dennis" wrote: How do I obtain the screen configuration of the system through codes of programming in Visual Basic? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Configuration
That will work for Excel VBA as well. I copied the code and pasted it at
the top of a new general module in Excel 2003. Then I went to the immediate window in the VBE and did: ? GetScreenResolution() 1024x768 As you can see, it returned the screen resolution as a string. -- Regards, Tom Ogilvy "Dennis" wrote in message ... Rowan thank you; But I need it to execute from Microsoft Excel through VBA. Really I ignore some commands from Microsoft Access. Do you help me? "Rowan" wrote: Have a look at http://support.microsoft.com/?id=148395 hope this helps Rowan "Dennis" wrote: How do I obtain the screen configuration of the system through codes of programming in Visual Basic? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen Configuration
Tom, Rowan, infinites thank you for helping me, he/she/it/you worked perfectly.
I proved this way: Debug.Print GetScreenResolution() Greetings! "Tom Ogilvy" wrote: That will work for Excel VBA as well. I copied the code and pasted it at the top of a new general module in Excel 2003. Then I went to the immediate window in the VBE and did: ? GetScreenResolution() 1024x768 As you can see, it returned the screen resolution as a string. -- Regards, Tom Ogilvy "Dennis" wrote in message ... Rowan thank you; But I need it to execute from Microsoft Excel through VBA. Really I ignore some commands from Microsoft Access. Do you help me? "Rowan" wrote: Have a look at http://support.microsoft.com/?id=148395 hope this helps Rowan "Dennis" wrote: How do I obtain the screen configuration of the system through codes of programming in Visual Basic? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Office 2007 configuration | Excel Discussion (Misc queries) | |||
Configuration of cells | Excel Discussion (Misc queries) | |||
general configuration? | Excel Discussion (Misc queries) | |||
Status Bar Configuration area | Excel Worksheet Functions | |||
Add-ins configuration and startup | Excel Programming |