[AccessD] Can't write to an Excel spreadsheet

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 





More information about the AccessD mailing list