Write to Excel from VB

Write to Excel from VB
Tom Wigginton

Writing to an Excel spreadsheet shouldn't be tough, but it can be. But reader Tom Wigginton offers this technique to make it easy.

------------------------------------------------------------

Here is a way you can read and write to an Excel spreadsheet using the Excel Application Object. GetExcel gets the contents of a cell in an Excel spreadsheet, while SetExcel writes to a cell in an Excel spreadsheet. If you are going to do a lot of reading and/or writing to an Excel spreadsheet, instead of instantiating and opening the Excel.Application and Excel.W...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT ARCHIVE: Tips & Tricks SearchVB wants your tips Find out what VS.NET modules are installed Retrieving icons from an EXE-file Toggling Boolean values VS.NET multiple tabbed windows Set the value of a DataField in code behind Easy grid design Open using last Visual Studio.NET layout Save development time by using inherited forms Reusing code in VS.NET

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

orkbook objects, then saving the changes, closing and destroying them in the functions, you can move that code outside of these functions. Create the Excel.Application and Excel.Workbook objects before getting or setting cell values, and save and close the Workbook and quit the Application object after getting or setting cell values.

------------------------------------------------------------

Thanks, Tom. For your interest in SearchVB, we'll be sending you a SearchVB denim shirt.

Tom Wigginton is a programmer/analyst with Alfa Insurance in Montgomery, Alabama, and a Microsoft Certified Professional.