save as latest excel format
 

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

save as latest excel format
 

nevermind I figured it out... message me if you need or care to know how
I got around this.


--
eluehmann
------------------------------------------------------------------------
eluehmann's Profile: http://www.excelforum.com/member.php...o&userid=13095
View this thread: http://www.excelforum.com/showthread...hreadid=437037