I've read lots of threads on this topic and cannot get anything to work for me. I understand that what I want to do involves VBA and automation. I don't know or understand VBA, so I'm hoping someone can just give me a short example that will work so I can figure things out on my own from there.
I have created a report that I want to automatically export to Excel when it is opened. I've gotten that to work using this code in the On Activate Event:
Code:
Private Sub Report_Activate()
DoCmd.OutputTo acOutputReport, "Presenter Data Report", acFormatXLS, "Presenter Data Report.xls", True
End Sub
Could someone provide code so that the resulting Excel file will have the top row bolded? I think from there I can figure out how to adjust other properties if I can get this to work. I do not want to create a preformatted Excel template. I want this to all work using VBA code in the On Activate Event.