Report in Microsoft Excel Sheet by using VB 6

Hi,

I what some sample programs which use Microsoft Excel to write a report from oracle tables


Thanks

I doubt if you will get a ready code here :rolleyes:

Try searching the codebank of www.vbworld.com, or sites such as www.planetsourcecode.com, www.vbcode.com etc for examples of automating Excel. You can ask specific questions about writing an application that will interact with MS Excel.

.

hi,

u want to read from oracle tables and insert into excel??? if so here is an alternative.

dim xlapp as new excel.application
dim xlwkb as new excel.workbook
dim xlwks as new excel.worksheet
dim db1 as new adodb.connection
dim rs as new adodb.recordset

set xlwkb=xlapp.workbooks.open("c:\temp.xls")
xlwkb.activesheet
db1.open "dsn=test;uid=scott;pwd=tiger;"
rs.open "select * from emp",db1
rs.cursorlocation=aduseclient
i=1
while not rs.eof
xlwkb.range("A" & i)=rs.fields("empl_Name")
rs.movenext
wend
xlwkb.save
xlwkb.close