LEADER 09280nam 2200565Ia 450 001 9910970090303321 005 20251117114954.0 010 $a1-280-54411-2 010 $a9786610544110 010 $a1-930919-17-4 035 $a(CKB)111086906312130 035 $a(MiAaPQ)EBC3301794 035 $a(Au-PeEL)EBL3301794 035 $a(CaPaEBR)ebr10110765 035 $a(CaONFJC)MIL54411 035 $a(OCoLC)923121693 035 $a(BIP)46087848 035 $a(BIP)6453928 035 $a(EXLCZ)99111086906312130 100 $a20010928d2000 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aMicrosoft Office automation with Visual FoxPro /$fTamar E. Granor, Della Martin ; edited by Ted Roche 210 $aWhitefish Bay, Wis. $cHentzenwerke Publishing$d2000 215 $axxi, 435 p. $cill 300 $aIncludes index. 311 08$a0-9655093-0-3 327 $aIntro -- Dedication -- Our Contract with You, The Reader -- List of Chapters -- Table of Contents -- Acknowledgements -- About the Authors -- How to Download the Files -- Introduction -- Section I Getting Started -- Chapter 1 Introducing Automation -- If all you have is a hammer, does that make everything a nail? -- A brief history of Automation -- OLE or ActiveX or COM or what? -- Putting Automation to work -- Where do you go from here? -- Chapter 2 The Office Servers -- Exploring the Office servers -- Read the fine manual (RTFM) -- Let the server write the code -- Take me for a browse -- At your command -- On-line and print resources -- Taking up a collection -- Changing the collection -- Self-referential object models -- Moving on -- Chapter 3 Visual FoxPro as an Automation Client -- Managing servers -- Displaying the Office servers -- Are we there yet? -- Working with servers -- SET OLEOBJECT -- Use WITH?ENDWITH -- Use variables for object references -- Loop with FOR EACH -- Debugging -- Work in the Command Window -- Collections and objects -- It works, but it doesn't -- Parameter problems -- Unhelpful error messages -- Use the Knowledge Base -- Ask around -- Time for code -- Section II Automating Word -- Chapter 4 Word Basics -- Word's object model -- Getting to Word -- Managing documents -- Accessing parts of a document -- Manipulating text -- Moving in a range or selection -- Bookmarks -- Formatting -- Setting up pages -- Setting fonts -- Formatting paragraphs -- Working with styles -- Borders and shading -- Headers and footers -- Page numbering -- Organizing text with lists -- Output -- Printing -- Print preview -- Putting it all together -- Chapter 5 Intermediate Word -- Document templates -- What goes into a template? -- Finding templates -- Using templates -- Creating templates -- Putting templates to work -- Tables -- Irregular tables. 327 $aCreating multi-column documents -- Footnotes and endnotes -- Adding graphics to documents -- The two faces of graphics -- Working with existing documents -- Search and replace -- Exploring document structure -- Traversing a document with the collections -- Automating macros -- Putting it all together -- Chapter 6 Advanced Word -- Organizing a document using styles -- Working with outlines -- Creating a table of contents -- Creating indexes -- Deciding what to index -- Marking items for the index -- Generating the index -- Formatting indexes -- Merging documents with data -- Word's mail merge structure -- Substituting data with Find and Replace -- Drop back 10 yards and punt -- Putting it all together -- Section III Automating Excel -- Chapter 7 Excel Basics -- The object model -- Déjà vu -- Getting a handle on the application -- Managing workbooks and worksheets -- Opening a new workbook -- Opening an existing workbook -- Saving the workbook -- Working with worksheets -- Rows, columns, cells, and ranges -- Handling values and formulas -- Adding, copying, and moving data (including formulas) -- Fill 'er up -- Formatting -- Column widths and alignment -- Fonts -- Formatting values -- Borders -- Shading -- Styles -- Output -- Page Setup -- Print Preview -- Printing -- Saving the data in different formats -- Putting it all together -- Chapter 8 Advanced Excel Features -- PivotTables -- PivotTable data -- Creating a PivotTable -- What-if analysis using data tables -- Goal Seek -- Protection -- Protecting a cell -- Protecting a worksheet -- Protecting a workbook -- Templates -- What goes into a template? -- Finding templates -- Using templates -- Creating templates -- Automating macros -- Adding shapes -- Adding pictures -- Putting it all together -- Chapter 9 Excel's Graphing Engine -- The object model -- Is it a chart or a sheet? -- Setting up the data. 327 $aRange names are your friend -- Creating a graph -- The ActiveChart property -- Off to see the wizard -- The anatomy of a chart -- Formatting the components -- The Chart object -- Chart types -- Chart object properties available only to 3D charts -- ChartArea -- The Border object -- The Interior object -- The Font object -- The PlotArea object -- Data series -- The Legend object -- Axes -- Titles -- Putting it all together -- Section IV Automating PowerPoint -- Chapter 10 PowerPoint Basics -- The PowerPoint object model -- Déjà vu -- Getting a handle on the application -- Managing presentations and slides -- Presenting: the Presentation object -- Opening an existing presentation -- Adding slides -- Saving the presentation -- Closing presentations -- Closing the application object -- Making it look good for the users -- Working with slide contents -- Using the slide layouts -- Adding and formatting text -- Making it presentable -- Putting it all together -- Chapter 11 PowerPoint Advanced Features -- Achieving consistency with Master Slides -- Backgrounds -- Standardizing the appearance of text -- Standardizing colors with ColorSchemes -- More on SlideMaster shapes -- Fancy features -- Animations -- Transitions -- Taking action -- Multimedia -- Sounding off -- Motion -- Adding notes -- Putting it all together -- Section V Automating Outlook -- Chapter 12 Automating Outlook -- The Outlook object model -- Getting a handle on Outlook -- Accessing Outlook's contents -- Sending e-mail -- Recipients and contacts -- Attaching files -- Manipulating the Contacts folder -- Adding appointments and tasks -- Putting it all together -- Section VI Advanced Topics -- Chapter 13 Inter-Office Communication -- Communicating between Office applications -- Copying and pasting between applications -- PasteSpecial -- Using AddOLEObject -- Communicating events with VFPCOM. 327 $aObtaining VFPCOM.DLL -- Using VFPCOM.DLL -- The last word -- Chapter 14 Handling Automation Errors -- Automation-specific errors -- The war of 1426-1429 -- Subtle differences -- Some interesting error observations -- Error-handling strategies -- ON ERROR and the Error method -- Preventing errors -- Wrapping it up -- Chapter 15 Wrapping Up the Servers -- Why wrap the servers? -- Structuring the wrapper classes -- Fundamental operations -- Talking to the user -- Creating a server instance -- Closing the server -- Opening a document -- Saving a document -- Other basic operations -- Creating subclasses -- Closing servers -- Opening a document, part 2 -- Closing a document -- Creating new documents -- Checking the server -- Checking open documents -- Keeping track of the active document -- Displaying the server -- Using the fundamental operations -- Adding server-specific operations -- Wrapping Word-from table to table -- Wrapping Excel-from table to graph -- Wrapping PowerPoint-standardizing text -- Wrapping it up -- Appendices -- Appendix A On-line User Communities -- FoxPro resources -- Office resources -- On-line etiquette -- Appendix B ChartWizard Values -- Index. 330 $aVisual FoxPro developers are used to building large, complex applications using only VFP as their programming environment. But Windows users are demanding more integration with other applications such as the Microsoft Office suite Word, Excel, PowerPoint and Outlook. Visual FoxPro can be used to automate either visually or behind the scenes any task or process that you could do manually in Office plus much more. In Microsoft Office Automation with Visual FoxPro, you ll learn how to create powerful applications that span the entire Office suite, using Visual FoxPro in the driver s seat. Granor and Martin have used Office Automation to perform a wide variety of complex, rigorous Automation tasks, including the assembly and production of the enormous Hacker s Guide to Visual FoxPro and large parts of the JFAST output modules used to brief the Joint Chiefs of Staff." 606 $aApplication software$xDevelopment 606 $aDatabase management 615 0$aApplication software$xDevelopment. 615 0$aDatabase management. 676 $a005.75/65 700 $aGranor$b Tamar E$01864433 701 $aMartin$b Della$01869529 701 $aRoche$b Ted$01860933 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910970090303321 996 $aMicrosoft Office automation with Visual FoxPro$94477705 997 $aUNINA