Export Access Table and format it in Excel



I have an MsAccess Table that i exported to Excel, now i have the file open,
but need to format de file dependig on other data i have in a table, can
anybody tell me how i can take control on this excel object.

Dim XlsArch As Excel.Workbooks

DoCmd.OutputTo acOutputTable, StrName, acFormatXLS, "D:\Piezas\" &
TxtNoParte & ".xls", True
Set XlsArch = ???? (i have to set the object, but how i should set it)

Thanks for your support.


sounds like the you need to write an Excel macro (or VBA sub) that works in
xl after the doc gets there.

(I did that in Word once)


How about recording a macro while you perform the steps within Excel, then
viewing the VBA code generated in the macro and using that code as an example
to generate your procedure within Access?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question