Make and format a Excel file fra Access VBA

[n0nick]

Hello!

I want to make a new MS Excel file from Access form, format the cells and then make a output of data from a table to the same file.

I know how to set properties of cells, rows and columns when i program in VBA when I am in a existing Excel file. But I have never worked with properties with a closed file, which I make through VBA.

Don't know if I did explain my problem well, but if somebody know the answer please write a small example of how to do it.

Thanks...

 

[PHV]

Have a look at OLE Automation (heywords: CreateObject, GetObject).
Another way is to pull the data from within Excel: menu Data -> External data -> ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[n0nick]

Ok, I knew that I got to use CreateObject to make a new file..but i ned referance of a object of this WorkSheet so I can change the properties to the cells,rows and columns.. I dont want to use the manual way to pull the data withing Excel.

 

[PHV]

I dont want to use the manual way to pull the data withing Excel
A QueryTable may refresh automatically.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886