Reverse columns and rows when exporting report to Excel

Asked Apr 21 '16 at 05:39

Active Apr 21 '16 at 05:39

Viewed 76 times

Exporting an access form to an excel file.

I have code which basically works, but enters all data in one row, instead of one column. Is this an easy fix?

Set fd = Application.FileDialog(msoFileDialogSaveAs)

If fd.Show Then
    Me.Filter = "[ID] = " & Me!ID
    Me.FilterOn = True
    DoCmd.OutputTo acOutputForm, "Checkride", "(*.xls)", fd.SelectedItems(1), True
    Me.FilterOn = False
End If

Separate question, based on the same code: If I simply enter a filename, this does not save the file as .xls file. I can type filename.xls, and it works, but that is not optimal. Is there something to change on the DoCmd line?

asked Apr 21 '16 at 05:39

Robert Kendall

[This answer](http://stackoverflow.com/questions/31867331/access-2013-accde-file-cant-export-to-acformatxlsx) is worth reviewing for alternates to using `DoCnd.OutputTo`. – OldUgly Apr 21 '16 at 06:02
What about transpose? – Forward Ed Apr 21 '16 at 06:36
Is there a way to use transpose while in Access? It looks like an Excel function. – Robert Kendall Apr 21 '16 at 16:56

Reverse columns and rows when exporting report to Excel

0 Answers0