I have a problem (don't we all)

I have access save a query as an XLS file then I have a macro run o
the file and save everything.

The problem is that access exports as a early version of excel and
make changes and push save but excel does not convert to the lates
format and I lose orientation of text when I reopen the file.

istead of workbooks.save is there something I can use that saves th
workbook as the laset version of excel?

I hope this is somewhat clear.

Or if you know access can I export but have it be the latest version o
excel

--
eluehman
-----------------------------------------------------------------------
eluehmann's Profile: http://www.excelforum.com/member.php...fo&userid=1309
View this thread: http://www.excelforum.com/showthread.php?threadid=43703