I am trying to create a button for me and other users to export reports to excel. using the ribbon the results are correct. using DoCmd.RunCommand AccmdExportExcel seem to give different results.
as I say using the export to excel gives the correct export but using the vba gives incorrect export results.
I have attached the 2 different versions of the export for you to see.
any advise on how to export this through vba.i really want to remove the ribbon and have functionality that I desire without the ability to be misused.
thank you
as I say using the export to excel gives the correct export but using the vba gives incorrect export results.
I have attached the 2 different versions of the export for you to see.
any advise on how to export this through vba.i really want to remove the ribbon and have functionality that I desire without the ability to be misused.
thank you