Export to Excel Format

[Woodpile]

Hello All,

I have several queries I export to Excel for publication. Is there a way to turn off Wrap Text in the resulting .xlsx file so I don't have to do it manually every time?


Thank you.

 

[JonXL]

How are you exporting?

 

[Woodpile]

JonXL,

Thank you for responding. I use a procedure to export each query. Here is a typical example. The only difference would be the query and target file name:

Private Sub Export_PCMS_No_Notif_Click()
'Exports All PCMS IWRs with No Notification

DoCmd.SetWarnings False

DoCmd.OutputTo acOutputQuery, "50- PCMS No Notification", "ExcelWorkbook(*.xlsx)", "\\BRCNA01A\Shared\INSP- PCMS No Notification.xlsx", False, "", , acExportQualityPrint

DoCmd.SetWarnings True

MsgBox "PCMS IWRs With No Notification Export Complete", vbOKOnly, "Function Progress"

End Sub

Hopefully this helps. This issue is not a show-stopper but it is annoying and takes time on a repetitive task.

Ed

 

[Micron]

I've read that in older Excel versions (xls) this could be prevented by sizing the table fields so that all the field content is showing without wrapping. No idea if you can solve this simply export as xls in newer versions. Your only option might be to use Automation on Excel from Access.

 

[SpillerBD]

Why aren't you pulling the data from Access using Excel's PowerQuery?

 

[Woodpile]

Spiller,

I did not know that was a possibility. I will look into that.
I have a lot of reports set up the way I know how to do them but if this works and makes sense, I will redo them.

This is a function I should look for in Excel?