VB School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become a VB Expert!

Join 307,131 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 2,058 people online right now. Registration is fast and FREE... Join Now!




reading excel files using vb

 

reading excel files using vb

inturn

3 Nov, 2009 - 05:02 AM
Post #1

New D.I.C Head
*

Joined: 3 Nov, 2009
Posts: 1

Dim xlApp As Excel.Application
Dim Wb As Excel.Workbook
Dim ws As Excel.Worksheet

Set xlApp = New Excel.Application
Set Wb = xlApp.Workbooks.Open("C:\sample.xls")

Set ws = Wb.Sheets(1)
Msgbox ws.Cells(1, 3)

User is offlineProfile CardPM
+Quote Post


MajorWalrus

RE: Reading Excel Files Using Vb

3 Nov, 2009 - 08:26 AM
Post #2

D.I.C Head
**

Joined: 22 Apr, 2009
Posts: 98



Thanked: 9 times
My Contributions
And so?
User is offlineProfile CardPM
+Quote Post

bytelogik

RE: Reading Excel Files Using Vb

4 Nov, 2009 - 02:08 AM
Post #3

D.I.C Head
**

Joined: 6 Oct, 2009
Posts: 63



Thanked: 5 times
My Contributions
And nothing ??
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/21/09 02:38PM

Live VB Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month