I am running the following code:
Dim fd2 As FileDialog
Dim Title2 As String
Dim vrtSelectedItem2 As Variant
Set fd2 = Application.FileDialog(msoFileDialogSaveAs)
.AllowMultiSelect = False
.Title = "Save File"
.InitialFileName = "Interiors By Workstream.xls"
If .Show = True Then
DoCmd.OutputTo acOutputReport, reportName, acFormatXLS, .SelectedItems(1), True
MsgBox "No file was selected"
It was working, now it does this upon an Office 2007 re-install. I had given me the 2587 error saying it can't complete the Output operation..and I have also seen something like format isn't available or soemthing like that.
Also, it doesn't work at all in Runtime. I have been all over EE and I know it is a known bug of sorts. Is there an alternative way to export a report to Excel? Reason I want to do the Report is I have subtotals calculated on the Report and the users like the way it 'was' coming out in Excel upon export.
Any other solutions to this problem will be more than welcomed.