# VB 6.0 and Excel objects

**URL:** https://boards.straightdope.com/t/vb-6-0-and-excel-objects/273438
**Category:** Factual Questions
**Created:** [November 7, 2004, 2:05am UTC](https://boards.straightdope.com/t/vb-6-0-and-excel-objects/273438 "2004-11-07T02:05:17Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![bizzwire](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@bizzwire](https://boards.straightdope.com/u/bizzwire)
#### Post date: [November 7, 2004, 2:05am UTC](https://boards.straightdope.com/t/vb-6-0-and-excel-objects/273438/1 "2004-11-07T02:05:17Z")

</div>

I am in the process of teaching myself Visual Basic (I know, I know…I’m a weenie) as a kind of on-the-job training project. I’m writing a program that tracks data across a variety of analytical instruments. So far, so good.

For reasons I won’t bore you with, at one stage the user will have to open and edit a textfile; this will really involve simple cut-and paste, copy, and fill-down operations, and I thought using an excel-like control would work nicely.

I have searched MSDN, all three of the “VB-for absolute nincompoops” books I’ve bought, the SDMB General questions forum," and am no closer to answering what should be an extremely simple task.

I can slap an Excel worksheet into a form; no problem. My question is how do I get the text from the text file and into the spreadsheet? And once it’s been edited to the user’s liking, how do I get it out? I’ve looked at the “OLE/COM” portion of my texts, but this seems much more involved and complex than what I need to do.

Any help greatly appreciated.