VB6 with excel file

[53050373]

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

[AIS4U]

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

[yadavrahul143]

'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...

[RobDog888]

See my FAQs on it.

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