J
J Shrimps, Jr.
Using
DoCmd.OutputTo acOutputTable, "tmptable", acFormatXLS, yada,yada
to export table to Excel on local hard drive.
Although fields in the tmp table are formated double/percent
the spreadsheet columns are not formated for percent.
Is there any way to format an export function to Excel keeping the percent
format?
DoCmd.OutputTo acOutputTable, "tmptable", acFormatXLS, yada,yada
to export table to Excel on local hard drive.
Although fields in the tmp table are formated double/percent
the spreadsheet columns are not formated for percent.
Is there any way to format an export function to Excel keeping the percent
format?