PDA

View Full Version : export to excel



tkaplan
11-29-2005, 10:34 AM
I'm not sure if i should post this on the access forum or excel, so i'll do both.

I have a query that if i export the query in excel format, i am given the option of "save formatted". i need this option to be set to no.
if i program a macro in excel to export the file for me, is there a parameter that it will set the option to no, because the default it yes.

Thank you,
tkaplan

Zack Barresse
11-30-2005, 03:41 PM
See: http://vbaexpress.com/forum/showthread.php?t=6219