DoCmd.OutputTo acOutputReport, "table1", acFormatXLS, Me.Application.CurrentProject.Path & "\test2.xls", False
Dim objXLBook As Excel.Workbook
Dim objXLSheet As Excel.Worksheet
Set objXLBook = Workbooks.Open(CurrentProject.Path & "\test2.xls")
Set objXLSheet = objXLBook.Worksheets("table1")
With objXLSheet
.Range("a1:g1").Select
With .Application.Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
.Application.Selection.Merge
End With
Me.Application.FollowHyperlink Me.Application.CurrentProject.Path & "\test2.xls"