VB6 with excel file

I'm a new programer, i'm writing a visual basic 6 project,

but i can't control excel file data from visual basic 6 code project

please help me.

thank's

53050373;

Welcome to VBForums:

Unfortunately you posted your question in the wrong thread. This is the VB.Net thread.

Maybe you should mark this thread Resolved and make a new posting in the VB 6.0 section.

Or, maybe one of the Moderators will notice it and move it for you.

Good Luck

Code:

---

'Add Reference to Microsoft Excel Object Library

Dim App_QA As Excel.Application
Dim Wb_QA As Excel.Workbook
Dim maxrow as Integer

Set App_QA = New Excel.Application
Set Wb_QA = App_QA.Workbooks.Open("Full Path of The Excel WorkBook")
Wb_QA.Worksheets(Sheet1).Select

maxrow = Wb_QA.ActiveSheet.UsedRange.Rows.Count

---

'Now u can handle the Excel as v do it in VBA.

Hope This will give u an idea... :wave:

See my FAQs on it.

http://vbforums.com/showthread.php?t=406640
http://vbforums.com/showthread.php?t=442132