Export Access Table and format it in Excel

J

JorgeB

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.
 
R

roger

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)
 
T

Ted

Jorge:
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

Similar Threads

Export Access Table to Excel in different sheet 1
Exporting table to Excel - getting error - help please. 2
export table and give it a name from the value in another unbound table 1
Fixed length when exporting to Excel 3
Object variable or With block variable not set 1
Output To flush data? 0
Format Excel - Object required error 5
Export Access Table with Memo Field to Excel 2

Top