Re: Show methods from Excel
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...
Re: Show methods from Excel
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:
Code:
Dim xlApp As Excel.Application
I recommend changing them back to "Object" (and removing the reference) before you compile the program.
Re: Show methods from Excel
Very Thank You
But, How can I to do export only a column from recordset to Excel ?:(:(
Re: Show methods from Excel
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.