Formatting when exporting to excel

M

Mike

Can anyone help me with some VBA for exporting to excel.
Right now I use the code below to create a spreadsheet
from a crosstab query.

DoCmd.OutputTo
acOutputQuery, "qryOpenPBConPriorityCountCrosstab",
acFormatXLS, "P:\Folder\PBContractorOpenItemCount", -1

What I need to do is include VBA to format the
spreadsheet. I need to insert a header with a title and
file export date. I would also like to insert a sum
formula to sum up the values of the columns. I have a
formula to sum across rows in the query, but not down a
column.

Your help is greatly appreciated
Mike
 

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

Some of the sum totals are exporting to Excel 0
Autonumber field in Excel that behaves the same as Access 0
Exporting multiple queries to multiple sheets within one excel fil 2
Consolidation Table from Different Excel Tabs with Different Format 1
Export Query to Excel 1
Rename Sheet1 on Excel Export 4
Access export to excel produces "unreadable data" 0
Language problem in exporting data 1

Top