Need help with generating an excel document using VB

[AnitaFitz]

Hi


I'm trying to generate an excel document using visual basic? I can preview the report fine but the users want me to generate the report to mirror an excel sheet and export.

I was browsing the net but can't find anything relevant except for 'DoCmd.OutputTo acOutputReport, "name of report", acFormatRTF, , True
which generates the data in a word document.


If anyone has any ideas I'd appreciate it.


Thanks


Anita

[kadghar]

Hi


I'm trying to generate an excel document using visual basic? I can preview the report fine but the users want me to generate the report to mirror an excel sheet and export.

I was browsing the net but can't find anything relevant except for 'DoCmd.OutputTo acOutputReport, "name of report", acFormatRTF, , True
which generates the data in a word document.


If anyone has any ideas I'd appreciate it.


Thanks


Anita

create an object with an excel application in it, then add to it anything you want

something like:

dim obj1 as object
set obj1 = createobject("excel.application")
obj1.visible=true
obj1.workbooks.add

Then you can add to it anything you want:

like

obj1.cells(1,1).value = "hello world"

or if you have an array with 10 elements, you can do:

with obj1.workbooks(1).worksheets(1)
    .range(.cells(1,1), .cells(1,10))= myarray
end with

hope that helps

[AnitaFitz]

It's exactly what I needed and it's worked perfectly.


Thanks very much for the help


Anita