Show methods from Excel

[mutley]

Hi

I have a code below

 Dim xlApp As Object

 'Create an instance of Excel and add a workbook
    Set xlApp = CreateObject("Excel.Application")
    Set xlWb = xlApp.Workbooks.Add
    Set xlWs = xlWb.Worksheets("Sheet1")

 with xlApp
    etc

 end with

When I put dot inside with, It did not show methods
I look References and reference of the excel is right


tia

[Siddharth Rout]

When you latebind with excel then you don't get intellisense however when you earlybind with excel then you will get what you want...


Early binding vs Late binding has been covered umpteen times in the forum... do a search and you will get what you seek Also check out the awesome tutorial by Si on how to interact with excel

Hope this helps...

[si_the_geek]

There is a link to the tutorial in my signature.

In this case all you need to do is declare the variables with their "proper" data types, eg:

Dim xlApp As Excel.Application

I recommend changing them back to "Object" (and removing the reference) before you compile the program.

[mutley]

Very Thank You

But, How can I to do export only a column from recordset to Excel ?

[si_the_geek]

If your recordset only contains that one column, the easiest way is CopyFromRecordset as shown in the tutorial.

If your recordset has other columns that you don't want to show, the easiest way is to loop the recordset, and use Cells or Range to put the values from that field into the worksheet.