[[ Microsoft Access cannot determine which row in your list or selection contains columns labels, which are required for this command ]]
Does anyone know how a method in VBA to suppress the above message while exporting to Excel, other than sending keys?
I'm using Access as a middle tier between Oracle and Excel; Access pulls the data from Oracle and outputs it to Excel in a required format, which includes subtotals. There are gaps between the columns in Excel, so Excel throws the above message as a warning, but everything works fine after I press Yes.
Tips: I tried using "DoCmd.SetWarnings (False)" , and it didn't work.
Right now I'm sending the ENTER "~" key twice, but it is causing other problems.
Thanks a lot!