object execel, word with vfoxpro

where I can find a manual of extrinsicos objects of excel and Word (.add, font.value, .HorizontalAlignment, .Font.size , etc, etc )to be used from Vfoxpro

urgent. how set a cell in excel to numeric format?

grazie

[233 byte] By [hebert] at [2008-2-4]
# 1
Excel:

http://msdn.microsoft.com/library/en-us/vbaxl11/html/Welcome_HV01134775.asp?frame=true&_r=1

Word:

http://msdn.microsoft.com/library/en-us/vbawd11/html/WordVBAWelcome_HV01135786.asp?frame=true

Note: you can download the docs or look under reference in the TOC.

MSDN Was giving me some troubles with these links. If they don't take you where you want, just look around the table of contents and if you dont find it do a search for:

Microsoft Excel 2003 Language Reference
Welcome to the Microsoft Office Word 2003 VBA Language Reference

search

Wodahs at 2007-9-8 > top of Msdn Tech,Visual FoxPro,Visual FoxPro General...
# 2
If you didn't install VBA help during office installation first install it. Check for VBAXLnn.CHM file under Office directory (location and file extension might differ slightly depending on version - ie: vbaxl.hlp for excel97).

Use NumberFormat = mask

CetinBasoz at 2007-9-8 > top of Msdn Tech,Visual FoxPro,Visual FoxPro General...
# 3

There is also a good article in UT Magazine:
http://www.utmag.com/September2002/Page45.asp

Here's the Excel Object Model:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrmicrosoftexcel2000.asp

And Word DOM:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrMicrosoftWord2000.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeomg/html/deovrobjectmodelguide.asp

There are also good examples at the Fox Wiki:
http://fox.wikis.com/wc.dll?Wiki~AutomationExamples

To use Automation you need a list of constants (Excel.h). You can get it in different ways. OPen the Object Browser from the menu or with: DO (_OBJECTBROWSER), load the Excel list (or Word) and open the Constants node. Then Drag and Drop to an editor page and now you have all the constants.

AlexFeldstein at 2007-9-8 > top of Msdn Tech,Visual FoxPro,Visual FoxPro General...