By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,345 Members | 2,404 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,345 IT Pros & Developers. It's quick & easy.

Connection Between VB6.0 and Excel

P: 1
I would like to know the steps in detail about how to establish the connection between VB6.0 and Excel.

ITS VERY URGENT
Jan 18 '08 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
Try to use the Data control.
Jan 18 '08 #2

kadghar
Expert 100+
P: 1,295
I would like to know the steps in detail about how to establish the connection between VB6.0 and Excel.

ITS VERY URGENT
Sure, open an excel application, and use any command allowed in VBA for excel. e.g:

Expand|Select|Wrap|Line Numbers
  1. dim obj1 as object
  2. set obj1 = createobject("excel.application")
  3. obj1.workbooks.open("c:\mybook.xls")
  4. msgbox obj1.activeworksheet.cells(1,1).value
HTH

PS: sorry for the late answer, but you posted the question when it was 3am in Mx.
Jan 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.