Use Macro to open a file with excel (underfined type of file)

Dear Mehmetcik

Thank you, thank error is no longer happen. It comes to another strange thing after the file is opened.

When the file is opened, there are many column and rows, the data are allocated in the respective cells correctly (the same as if i open the file manually with excel program).

some of the columns are "dates", i mean the information of the cell is a "date"
some are fine, but some of them are wrong format.

For example, some dates are "13-12-14" but some are "9/1/2013", i have tried to select them and manually change format, but it fails; regarding this, I realize that is a small green triangle show at the cells which have bad format "13-12-14". I have to manually click on the green triangle to fix the cell one by one. (I would like to have all date in the format of dd/mm/yyyy)

Can the macro cater for this?

Thank you very much.