UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

hadji's VB.NET QOTM	by hadji	2008-07-29 12:28:00
I'm trying to work with an Excel spreadsheet, and populate it with values. I have this line to open the spreadsheet: workbook = GetObject(Config.excelfile) Then I do various things, and I have this line to populate a cell: workbook.worksheets(1).cells(capacityrow, item.index).value = item.capacity After that, do I have to include in my code functions to save and close the spreadsheet? I can't seem to find out how to do that. A bit of googling pointed me to: workbook.save workbook.close But the code looked like VB script rather than VB.net, so I'm not sure if it applies.
[ Reply ]
There's only one way to find out...	by Bellator	2008-07-29 12:31:13
That's what I've been doing, but I'm not getting	by hadji	2008-07-29 12:33:09
If I write to the cell, then read from it,	by hadji	2008-07-29 12:32:12
Does this article help?	by merlin	2008-07-29 12:44:00

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)