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?
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?
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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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, 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks