Gustav Brock
Gustav at cactus.dk
Sat Jan 7 05:54:07 CST 2006
Hi all Please note this date. JC in modest mode! However, JC and other class freaks, did you notice last month's public article in Smart Access on accessing Excel via a class? <quote> In this article, Garry Robinson shows you how to use a class to manipulate Microsoft Excel. His class provides a software layer that hides the complexity of dealing with Excel through VBA. You'll see how to use Garry's class to push single pieces of data into Excel, how to transfer data from queries into Excel, and how to let users navigate between results using bookmarks. </quote> The article requires subscription now but the download with code etc. is still there: http://www.pinpub.com/Media/PublicationsArticle/512robinson_SA05l.zip 'fxCm--> FXc8_Excel ... Class library for Automating Microsoft Excel 'fxCm 'fxCm The calls to the class module defined below rely on the 'fxCm following declaration in the software that you are using 'fxCm 'fxCm Public Excel_FX As New FXc8_Excel 'fxCm 'fxCm So when the class module is called, the notes specify Excel_FX rather than 'fxCm FXc8_Excel 'fxCm 'fxCm Requires a reference to the following non standard libraries 'fxCm 'fxCm Microsoft Excel 8 (97) or 9 (2000) Object library 'fxCm 'fxCm Originally developed by GR-FX Pty Limited in Australia. 'fxCm Can be modified and used by customers who purchase the rights to the software 'fxCm 'fxCm Additional Methods and Properties 'fxCm 'fxCm Search for the following commented lines and remove the comments to add the 'fxCm additional methods to the class module. 'fxCm 'fxCm 'Cube - Methods that allow you to change Excel 2000 cube objects 'fxCm 'AccSQL - Method to load Access SQL into Excel 'fxCm 'fxCm Jul 99 GR - Original 'fxCm Oct 1999 GR - Modified for FX Classes library 'fxCm Nov 1999 GR - Excel chart rows output issues 'fxCm Nov 1999 GR - Different error handling sequence for opening Excel Templates 'fxCm Dec 1999 GR - Added transpose as an option 'fxCm Jan 2000 GR - Refining worksheet swaping methods 'fxCm Jan 2000 GR - Added DAO. to necessary objects to avoid confusion with ADO objects. 'fxCm Feb 2000 GR - Change OpenExcel to accomodate optional sheetnames 'fxCm GR and SQLData bug 'fxCm June 2000 GR - Add open Excel spreadsheet 'fxCm " " " Modified delete rows method for greater speed 'fxCm Sep 2000 GR - Added GetCellValue 'fxCm Oct 2000 GR - Upgraded GetCellValue for errors in Excel cells 'fxCm Nov 2000 GR - Added moveToReference method 'fxCm Nov 2000 GR - Added Printout method 'fxCm Nov 2000 GR - Mods to closedown method 'fxCm Nov 2000 GR - Added print preview 'fxCm Dec 2000 GR - Added CopyAccessQuery, RenameWorksheet, AddWorksheet 'fxCm and TextBookmarks methods 'fxCm Mar 2002 GR - Added CopyData to use faster CopyFromRecordset method 'fxCm Mar 2002 GR - Added InsertRows 'fxCm Mar 2002 GR - Added AddChart method 'fxCm Mar 2002 GR - Added DeleteWorksheet method /gustav >>> jwcolby at ColbyConsulting.com 06-01-2006 20:20 >>> Yea, I already have automation figured out (I think). John W. Colby www.ColbyConsulting.com