Send data to excel and format the spreadsheet automatically

[JorgeB]

I have some data in an access table, i have to export it to an excel
spreadsheet after that i have to format the spreadsheet. The question is how
i can control excel thru access.

Thanks in advance.

 

[Alex Dybenko]

Hi,
look here:
http://www.mvps.org/access/modules/mdl0006.htm

you can also format, etc same way. Run macro recording in excel, set
required format and then check what VBA code Excel generated. Then you can
use it from access like in provided link

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com