Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automatic save Excel file in latest format

Status
Not open for further replies.
theresatan

theresatan

Programmer
Mar 18, 2002
101
US

Hi:

I need to extract the data from Excel files (about 1000) that are incompatible with my Excel 2003/2000.

When I open them with Excel 2000/2003, I got a prompt as follow:

xxx.xls may contain features that are not compatible with Text (Tab delimited). Do you want to keep the workbook in this format?

.To keep this format, which leaves out any incompatible features, click Yes.
.To preserve the features, click No. Then save a copy in the latest Excel format.
.To see what might be lost, click Help.

When I click NO and save a copy in the latest Excel format, then I can use openQuery to extra the data.

Is there a way to automatic save those Excel files in latest format?

Thanks in advance

Theresa

 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
125
Swi
Swi
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
320
strongm
strongm
sal21
  • Locked
  • Question
Replace , with ; in txt file
Replies
7
Views
183
muaricewayne
muaricewayne
sal21
  • Locked
  • Question
FORMAT output of Debug.Print .responseText (from api rest)
Replies
4
Views
185
2009luca
2009luca
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
213
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top