save as latest excel format

  • Thread starter Thread starter eluehmann
  • Start date Start date
E

eluehmann

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
 
nevermind I figured it out... message me if you need or care to know how
I got around this.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
How can we convert OST to PDF file format? 1
Saving a Word document as PDF from en Excel macro 2
saving in other File types 2
Lose macros before saving 4
How to Convert MBOX to PST Online? 3
Using ExportAsFixedFormat 3
Not saving as xls file 1

Back
Top