Macro to Save as from HTML to XLS

Hi all,

I have a problem with files I extract automatically from a tool, which should save them as .XLS, but in fact saves in .HTML format.

These are daily reports which at the end of the month populate another file, by using vlookup.

Because the files are saved in html format, vlookup does not read them and I have to open each one and Save it as .xls

What I would like to do is to create a macro which would open the folder where those files are and automatically save them into .xls with exactly the same name.

Is there anyone who can assist me in doing this?

Thank you for your assistance.
Pedro

hi Patel,

Thank you for your assistance. Here's the file which is created by my reporting tool.

This is then saved into a folder, but when I open it it says it is in html format. Then I need to do a Save As xls and it becomes available for my other excel file to extract the necessary information.

If you could assist with a macro which would allow me to open and save as all these documents I would really appreciate.

thanks,
pedro

Hi Patel,

I probably did not explain correctly what is happening.

I am extracting the file I sent to you and it actually saves as .xls because the script which makes the report dictates it should be saved with extension .xls, when in fact the format is .html

Îf you try to open that file in excel you will receive a message stating that the file has been saved in a different format then the extension it has.

I click 'Yes' to open the file and then to make a real .xls file I have to go to file, Save As, choose the Save As Type (which you will see shows as html) and then save it as .xls.

That is what happens and I have to open 30 files every month and do this same action.

Hope this has clarified and sorry for the time wasted.
Pedro

Hi Patel,

Just tried it and it doesn't work, because it opens my file (changed the name and location) but crashes in the following line.

All you need is code that opens the file and re-saves it. Are you doing this one by one or in a batch?

You'll obviously need to change the filename in Patel's code and replace the extension with xls