Error opening file......"different format than what specified by extension"...

hi,

That is one option i had not thought of but i would rather (if possible) have the macro somehow ignore the error. I have tried "on error resume next" but program execution just stops after file is opened.

Here is a copy of the file that i am having trouble opening. I can open the file but program execution stops just after the file is opened.

Does anyone know how to open this file using VBA?

Can anyone help?

hi,

Renaming file will allow me to read in THIS file but if i rename all files with ".xls" extension to ".xlsx" then i will have a problem other files. Does this make sense? Renaming the file will fix only a specific problem with this file type. The other files with a ".xls" extension which are "correct", if i rename them then i will have a problem.

There is a problem with the excel file i uploaded. I had to remove some personal information and apparently is does not want to open up AT ALL.

Even changing the extension to ".xlsx" does not seem to work now.

Turns out the file that i am trying to read in........i think its an html file.

the file is created from a web based software. It is automatically saved as an excel file. I dont know if its excel 2007 or 2003 format. I do know its an HTML file type. Excel reads it in ok as long as i change the extension to .html.

An earlier person suggested i rename the file extension using excel. Does anyone know how to do this in VBA?

Or if i can somehow select the file to open and then instruct excel its an html file that would work also......i think.

thanks shg,

i appreciate your help.

for now at least i have a work around and i can open the file.

Thanks.