|
-
Sep 25th, 2003, 08:33 PM
#1
Thread Starter
Lively Member
Excel ???
This is the code that I have to input some values from an excel file. The problem is that now I want to open the book and go to a specific worksheet.
Can anyone help?
Reston
Private Sub cmdReadXL_Click()
oXL.Workbooks.Open "C:\ThkCalcs.xls"
oXL.Visible = False
txt3 = oXL.Cells.Range("E12", "E12").Value
txt1 = oXL.Cells.Range("E19", "E19").Value
txt2 = oXL.Cells.Range("I12", "I12").Value
txt4 = oXL.Cells.Range("I19", "I19").Value
txt5 = oXL.Cells.Range("B29", "B29").Value
txt6 = oXL.Cells.Range("B30", "B30").Value
oXL.Workbooks.Item("WFLthkCalcs68.xls").Close
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|