Excell Export Format

J

jk

I have the following action to export from a command button:

DoCmd.OutputTo acOutputQuery, "qryCustomerInvoices3", acFormatXLS, _
strPath & "\" & strFile ', 0
DoCmd.TransferSpreadsheet _
TransferType:=acExport,
TableName:="qryCustomerInvoices2", _
FileName:=strPath & "\" & strFile,
HasFieldNames:=True

The export works great but while the first sheet has all the format labels
and columns aligned, the second sheet created needs to be manually adjusted
to open viewable spaces. Is there a way that the second sheet can be exported
in the same clean format as the first?
 

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

Case select on output 1
TransferSpreadsheet to .xlsx format 4
Automate export to Outlook 2
I need help with wrapping text in excel 2
Problem exporting multiple tables into different worksheets in oneworkbook 3
Help with my code Exporting to multiple excel spreadsheets 3
reate relationship as each excel table is imported VBA 1
Format Export to Excel error 8

Top