ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Screen Configuration (https://www.excelbanter.com/excel-programming/335847-re-screen-configuration.html)

Rowan[_2_]

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?


dennis

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?


Tom Ogilvy

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?




dennis

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?






All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com