Creating Excel Sheets

I am using some recycled code from the MSDN for creating Excel sheets (I
cannot find the original msdn page). basically this code creates an object
named oExcelSheet with this object (yes I am aware there is more to it) I
can insert data into the sheet by doing oExcelSheet.cells(5,2).value = "Ref
Month". So I understand how it basically works, where it says .value I can
change it to .font to do different things to the sheet. Does anyone know
where I can find all the different commands? IE. .cells, .value and all the
good ra ra?

Altman
Mon Nov 29 15:19:08 CST 2004

do a search for the file VBAXL10.CHM on your computer. It is a compiled
help file that contains the properties and methods of all objects inside of
Excel.


"Keht" <NoVirus@IHateScriptKiddies.com> wrote in message
news:u3HFiTl1EHA.3120@TK2MSFTNGP12.phx.gbl...
>I am using some recycled code from the MSDN for creating Excel sheets (I
> cannot find the original msdn page). basically this code creates an object
> named oExcelSheet with this object (yes I am aware there is more to it) I
> can insert data into the sheet by doing oExcelSheet.cells(5,2).value =
> "Ref
> Month". So I understand how it basically works, where it says .value I
> can
> change it to .font to do different things to the sheet. Does anyone know
> where I can find all the different commands? IE. .cells, .value and all
> the
> good ra ra?
>
>

TomNorwood
Mon Nov 29 15:23:08 CST 2004

I don't know if it's all documented anywhere, but the best way I've found to
do this is to create a macro in Excel, do whatever you want to do, then use
the code that is generated by the macro (with a few changes to make it
FoxPro-legal).

"Keht" wrote:

> I am using some recycled code from the MSDN for creating Excel sheets (I
> cannot find the original msdn page). basically this code creates an object
> named oExcelSheet with this object (yes I am aware there is more to it) I
> can insert data into the sheet by doing oExcelSheet.cells(5,2).value = "Ref
> Month". So I understand how it basically works, where it says .value I can
> change it to .font to do different things to the sheet. Does anyone know
> where I can find all the different commands? IE. .cells, .value and all the
> good ra ra?
>
>
>

Altman
Mon Nov 29 15:40:41 CST 2004

Also intellisense can be very useful, add the excel object to your
intellisense and then declare oExcelSheet as a Excel.Worksheet. Then when
you hit the . you will get a listing of what is available.


"Altman" <NotGiven@SickOfSpam.com> wrote in message
news:uPi6Rkl1EHA.412@TK2MSFTNGP14.phx.gbl...
> do a search for the file VBAXL10.CHM on your computer. It is a compiled
> help file that contains the properties and methods of all objects inside
> of Excel.
>
>
> "Keht" <NoVirus@IHateScriptKiddies.com> wrote in message
> news:u3HFiTl1EHA.3120@TK2MSFTNGP12.phx.gbl...
>>I am using some recycled code from the MSDN for creating Excel sheets (I
>> cannot find the original msdn page). basically this code creates an
>> object
>> named oExcelSheet with this object (yes I am aware there is more to it) I
>> can insert data into the sheet by doing oExcelSheet.cells(5,2).value =
>> "Ref
>> Month". So I understand how it basically works, where it says .value I
>> can
>> change it to .font to do different things to the sheet. Does anyone know
>> where I can find all the different commands? IE. .cells, .value and all
>> the
>> good ra ra?
>>
>>
>
>

tom
Tue Nov 30 04:02:55 CST 2004

Hi,

in addition to the mentioned help file and object inspecor / intellisense :

have a look at the book about office automation from hentzenwerke. You will
find lots of information and good sourcecode for common problems in
automating excel,word,powerpoint,outlook.
They also document the meanings of all this ".something", the
inspector/intellisense only lists the calls (not the meaning)

Greetings
Tom


"Keht" <NoVirus@IHateScriptKiddies.com> schrieb im Newsbeitrag
news:u3HFiTl1EHA.3120@TK2MSFTNGP12.phx.gbl...
> I am using some recycled code from the MSDN for creating Excel sheets (I
> cannot find the original msdn page). basically this code creates an object
> named oExcelSheet with this object (yes I am aware there is more to it) I
> can insert data into the sheet by doing oExcelSheet.cells(5,2).value =
"Ref
> Month". So I understand how it basically works, where it says .value I
can
> change it to .font to do different things to the sheet. Does anyone know
> where I can find all the different commands? IE. .cells, .value and all
the
> good ra ra?
>
>

Zeke
Tue Nov 30 04:06:45 CST 2004

I recomment the book "Microsoft Office Automation with Visual Foxpro" by
Tamar E Granor. It is an excellent starting point and gives you good insight
in Excel as well as Word, Powerpoint and Outlook automation.

One other good method is to record a macro in Excel and then convert it into
Foxpro syntax.

Zeke


"Keht" <NoVirus@IHateScriptKiddies.com> wrote in message
news:u3HFiTl1EHA.3120@TK2MSFTNGP12.phx.gbl...
> I am using some recycled code from the MSDN for creating Excel sheets (I
> cannot find the original msdn page). basically this code creates an object
> named oExcelSheet with this object (yes I am aware there is more to it) I
> can insert data into the sheet by doing oExcelSheet.cells(5,2).value =
"Ref
> Month". So I understand how it basically works, where it says .value I
can
> change it to .font to do different things to the sheet. Does anyone know
> where I can find all the different commands? IE. .cells, .value and all
the
> good ra ra?
>
>

Sietse
Tue Nov 30 05:01:22 CST 2004

And don't forget about the object browser!
Press the Open Type Library button, Select the COM Libraries tab, press the
Browse button, Navigate to the Office directory, select *.olb for 'Files of
type', select XL?????.olb
Particulary handy are the constants and Enums nodes in the tree for the
values of the used constants, if you do't use a header file

HTH,
Sietse Wijnker


"Keht" <NoVirus@IHateScriptKiddies.com> wrote in message
news:u3HFiTl1EHA.3120@TK2MSFTNGP12.phx.gbl...
>I am using some recycled code from the MSDN for creating Excel sheets (I
> cannot find the original msdn page). basically this code creates an object
> named oExcelSheet with this object (yes I am aware there is more to it) I
> can insert data into the sheet by doing oExcelSheet.cells(5,2).value =
> "Ref
> Month". So I understand how it basically works, where it says .value I
> can
> change it to .font to do different things to the sheet. Does anyone know
> where I can find all the different commands? IE. .cells, .value and all
> the
> good ra ra?
>
>