Auto Change Excel worksheet file type

[teel73]

I have a macro that simply runs a TransferSpreadheet action. However it doesn't import the spreadsheet because of the file type (Web Page *.html; *htm). Once I open the spreadsheet and manually change the file type to (Microsoft Office Workbook .xls) then the macro works.

Is there a way to auto change the file type of the Excel file before importing it?

 

[Guus2005]

Why does the spreadsheet contain a htm extension in the first place?

You can use FileCopy to copy the htm file to a spreadsheet before opening.

HTH