Is it possible to export data to an excel template starting at sheet1 cell A:5?
How do you delete existing content without deleting the existing format.
Currently I use this code:
If Dir("C:\MyFolder\Projects.xls") <> "" Then
If MsgBox("This action will create a spread sheet file listing all projects. Do you want to REPLACE the existing Excel File with this later version?", vbYesNo) = vbYes Then
DoCmd.OpenQuery "Projects", acNormal, acEdit