Hello

I have used VBA to export a recordset to an Excel template and save the file as an .xls. However, when I open the Excel file the workbook is hidden. I use the Menu;Window:Unhide command to Unhide the workbook

My code is straight forward but I must be missing something.

Thanks for any help you can give me.

One thing I do is use the open event in excel so when you open the file it pulls from excel (instead of pushing from access)

open excel > goto tools / macro / vb editor > click on this workbook and on the top left combo click workbook and on the top right click open you should have this:

Private Sub Workbook_Open()
   Stop
End Sub

...where it says stop type in the code, i tested it and it hit stop right away when i opened it. All you have to do then is open the file from access, the code will trigger even if opened from access. Save the file as a template, just an idea.