Excel COM function list.
 

Hey group,

I programming in PHP5, accessing Excel through COM and would like to find
a function list as I hear there are about 300+ functions. Any help would be
appreciated!

Thanks,
Norman Peelman

Excel COM function list.
 

Thanks,

I learned about that and have been looking through it. I was hoping to
find some info that would a bit more descriptive. I have figured out how to
do some things, but others elude me. Like, how would I change the
background (fill) color of a cell/range? I've tried 'BackColor' but i'm not
getting anywhere. Also I need to figure out the algorythm to create a RGB
long color value from the separate RED GREEN BLUE.

Thanks again,

Norm


--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
Norman,

Do you mean the methods available to you in the Excel object model? If so,
you should be able to see all of these by going into the Object Browser in
Excel VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
.. .
Hey group,

I programming in PHP5, accessing Excel through COM and would like to
find
a function list as I hear there are about 300+ functions. Any help would
be
appreciated!

Thanks,
Norman Peelman

Excel COM function list.
 

myRange.interior.colorindex=35

or myRange.interior.color = 65535

or even myRange.interior.color=rgb(&H80,&h0,&h80)

Here is the algorithm for the latter
vRed = &H80
vGreen = &H0
vBlue = &H80

vColour = vBlue * 256 ^ 2 + vGreen * 256 + vRed



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thanks,

I learned about that and have been looking through it. I was hoping to
find some info that would a bit more descriptive. I have figured out how
to
do some things, but others elude me. Like, how would I change the
background (fill) color of a cell/range? I've tried 'BackColor' but i'm
not
getting anywhere. Also I need to figure out the algorythm to create a RGB
long color value from the separate RED GREEN BLUE.

Thanks again,

Norm


--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
Norman,

Do you mean the methods available to you in the Excel object model? If
so,
you should be able to see all of these by going into the Object Browser
in
Excel VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
.. .
Hey group,

I programming in PHP5, accessing Excel through COM and would like
to
find
a function list as I hear there are about 300+ functions. Any help
would
be
appreciated!

Thanks,
Norman Peelman

Excel COM function list.
 

Thank you very much!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...

myRange.interior.colorindex=35

or myRange.interior.color = 65535

or even myRange.interior.color=rgb(&H80,&h0,&h80)

Here is the algorithm for the latter
vRed = &H80
vGreen = &H0
vBlue = &H80

vColour = vBlue * 256 ^ 2 + vGreen * 256 + vRed



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thanks,

I learned about that and have been looking through it. I was hoping
to
find some info that would a bit more descriptive. I have figured out
how
to
do some things, but others elude me. Like, how would I change the
background (fill) color of a cell/range? I've tried 'BackColor' but i'm
not
getting anywhere. Also I need to figure out the algorythm to create a
RGB
long color value from the separate RED GREEN BLUE.

Thanks again,

Norm


--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
Norman,

Do you mean the methods available to you in the Excel object model? If
so,
you should be able to see all of these by going into the Object
Browser
in
Excel VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
.. .
Hey group,

I programming in PHP5, accessing Excel through COM and would like
to
find
a function list as I hear there are about 300+ functions. Any help
would
be
appreciated!

Thanks,
Norman Peelman

Excel COM function list.
 

By the way, going the other way, long to RGB

vColour = 8388736
vRed = vColour And &HFF
vGreen = vColour \ 256 And &HFF
vBlue = vColour \ 256 ^ 2 And &HFF

ActiveCell.Interior.Color = RGB(vRed, vGreen, vBlue)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thank you very much!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...

myRange.interior.colorindex=35

or myRange.interior.color = 65535

or even myRange.interior.color=rgb(&H80,&h0,&h80)

Here is the algorithm for the latter
vRed = &H80
vGreen = &H0
vBlue = &H80

vColour = vBlue * 256 ^ 2 + vGreen * 256 + vRed



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thanks,

I learned about that and have been looking through it. I was hoping
to
find some info that would a bit more descriptive. I have figured out
how
to
do some things, but others elude me. Like, how would I change the
background (fill) color of a cell/range? I've tried 'BackColor' but
i'm
not
getting anywhere. Also I need to figure out the algorythm to create a
RGB
long color value from the separate RED GREEN BLUE.

Thanks again,

Norm


--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
Norman,

Do you mean the methods available to you in the Excel object model?
If
so,
you should be able to see all of these by going into the Object
Browser
in
Excel VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
.. .
Hey group,

I programming in PHP5, accessing Excel through COM and would
like
to
find
a function list as I hear there are about 300+ functions. Any help
would
be
appreciated!

Thanks,
Norman Peelman

Excel COM function list.
 

Bob,

Thanks for the info... I finally found the proper place on microsofts'
site. Things are rolling now!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
By the way, going the other way, long to RGB

vColour = 8388736
vRed = vColour And &HFF
vGreen = vColour \ 256 And &HFF
vBlue = vColour \ 256 ^ 2 And &HFF

ActiveCell.Interior.Color = RGB(vRed, vGreen, vBlue)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thank you very much!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...

myRange.interior.colorindex=35

or myRange.interior.color = 65535

or even myRange.interior.color=rgb(&H80,&h0,&h80)

Here is the algorithm for the latter
vRed = &H80
vGreen = &H0
vBlue = &H80

vColour = vBlue * 256 ^ 2 + vGreen * 256 + vRed



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thanks,

I learned about that and have been looking through it. I was
hoping
to
find some info that would a bit more descriptive. I have figured
out
how
to
do some things, but others elude me. Like, how would I change the
background (fill) color of a cell/range? I've tried 'BackColor' but
i'm
not
getting anywhere. Also I need to figure out the algorythm to create
a
RGB
long color value from the separate RED GREEN BLUE.

Thanks again,

Norm


--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
Norman,

Do you mean the methods available to you in the Excel object
model?
If
so,
you should be able to see all of these by going into the Object
Browser
in
Excel VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
.. .
Hey group,

I programming in PHP5, accessing Excel through COM and would
like
to
find
a function list as I hear there are about 300+ functions. Any
help
would
be
appreciated!

Thanks,
Norman Peelman

Excel COM function list.
 

Where is that Norman?

Bob

"Norman Peelman" wrote in message
. ..
Bob,

Thanks for the info... I finally found the proper place on microsofts'
site. Things are rolling now!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
By the way, going the other way, long to RGB

vColour = 8388736
vRed = vColour And &HFF
vGreen = vColour \ 256 And &HFF
vBlue = vColour \ 256 ^ 2 And &HFF

ActiveCell.Interior.Color = RGB(vRed, vGreen, vBlue)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thank you very much!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...

myRange.interior.colorindex=35

or myRange.interior.color = 65535

or even myRange.interior.color=rgb(&H80,&h0,&h80)

Here is the algorithm for the latter
vRed = &H80
vGreen = &H0
vBlue = &H80

vColour = vBlue * 256 ^ 2 + vGreen * 256 + vRed



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thanks,

I learned about that and have been looking through it. I was
hoping
to
find some info that would a bit more descriptive. I have figured
out
how
to
do some things, but others elude me. Like, how would I change the
background (fill) color of a cell/range? I've tried 'BackColor'
but
i'm
not
getting anywhere. Also I need to figure out the algorythm to
create
a
RGB
long color value from the separate RED GREEN BLUE.

Thanks again,

Norm


--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in
message
...
Norman,

Do you mean the methods available to you in the Excel object
model?
If
so,
you should be able to see all of these by going into the Object
Browser
in
Excel VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
.. .
Hey group,

I programming in PHP5, accessing Excel through COM and
would
like
to
find
a function list as I hear there are about 300+ functions. Any
help
would
be
appreciated!

Thanks,
Norman Peelman

Excel COM function list.
 

This URL should drop you right in at the top of the function list:

http://msdn.microsoft.com/library/de...lproaccent.asp

This is for OfficeXP. I haven't located the 97 info yet (that's what i'm
playing with now).

Norm

--
Avatar hosting at www.easyavatar.com

"Bob Phillips" wrote in message
...
Where is that Norman?

Bob

"Norman Peelman" wrote in message
. ..
Bob,

Thanks for the info... I finally found the proper place on microsofts'
site. Things are rolling now!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...
By the way, going the other way, long to RGB

vColour = 8388736
vRed = vColour And &HFF
vGreen = vColour \ 256 And &HFF
vBlue = vColour \ 256 ^ 2 And &HFF

ActiveCell.Interior.Color = RGB(vRed, vGreen, vBlue)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thank you very much!

Norm

--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in message
...

myRange.interior.colorindex=35

or myRange.interior.color = 65535

or even myRange.interior.color=rgb(&H80,&h0,&h80)

Here is the algorithm for the latter
vRed = &H80
vGreen = &H0
vBlue = &H80

vColour = vBlue * 256 ^ 2 + vGreen * 256 + vRed



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
. ..
Thanks,

I learned about that and have been looking through it. I was
hoping
to
find some info that would a bit more descriptive. I have
figured
out
how
to
do some things, but others elude me. Like, how would I change
the
background (fill) color of a cell/range? I've tried 'BackColor'
but
i'm
not
getting anywhere. Also I need to figure out the algorythm to
create
a
RGB
long color value from the separate RED GREEN BLUE.

Thanks again,

Norm


--
Avatar hosting at www.easyavatar.com
"Bob Phillips" wrote in
message
...
Norman,

Do you mean the methods available to you in the Excel object
model?
If
so,
you should be able to see all of these by going into the
Object
Browser
in
Excel VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Peelman" wrote in message
.. .
Hey group,

I programming in PHP5, accessing Excel through COM and
would
like
to
find
a function list as I hear there are about 300+ functions.
Any
help
would
be
appreciated!

Thanks,
Norman Peelman