vb question

DramaKing

11-21-2001, 05:47 PM

Can I edit excel files by using VB programs?
thx!!

Timbo

11-21-2001, 06:07 PM

yes - you will require a reference to 'MS Excel Object Library' in your project.

DramaKing

11-21-2001, 06:42 PM

Would u mind telling me more details about it? Or some webs? Thx!!

Timbo

11-21-2001, 06:54 PM

THIS THREAD (http://www.visualbasicforum.com/bbs/showflat.php?Cat=&Board=vba&Number=62259&page=&view=&sb=&o=&vc=1) came up in a search for 'Excel VB', but there's plenty more stuff there...

DramaKing

11-21-2001, 06:59 PM

Oh!! thx!! It seems really hard for me.
By the way, what materials that I need for doing this program?
Thx!

Thinker

11-21-2001, 07:09 PM

You do have to have Excel to do it. What you will be doing is starting Excel
up and manipulating it from VB. If you were asking how to work with a
spreadsheet without using Excel at all, you probably won't get an answer.