How to save .htm (HTML) extension excel file as .xls excel file

[vishnu01445]

Hello All,

I am new to VBA.I have one situation, where I have to save htm extension files as excel file. Please advise me how to do it.

I will download excel files from a web based application, the excel is opening with htm extension. I want to write macro(VBA) to save the file in a common folder and it has to take name from a cell of the file, which i downloaded from web based application.

While trying to accessing the excel file(downloaded file) through VBA, VBA is not recognizing it as excel because of the file extension(htm).

Appreciate your help in this situation.

Thanks & Regards,
Vishnu V

[vishnu01445]

Hello All,

Could you please help me ???

Thanks,
Vishnu V

[VBee]

Are you sure the file you are downloading is a valid excel file?

Can you try opening it with notepad and pasting part of the contents here?

[vishnu01445]

Hello,

Yes, it is opening in excel only(actually it is a excel file downloaded from a web based application, while we downloading it is coming with htm extension).

Thanks,

[VBee]

Can you not force the web application to save the downloaded file with a .xls extension for example?

It might be worth looking into MIME

[vishnu01445]

No, i cannt.after i download the file from the web application, i have to save the file as excel manually everytime.

[VBee]

Well this is more of an issue with the web application then, did you write it yourself?

[vishnu01445]

Yes, i have logic for this macro, but i got struck with this issue.

[VBee]

Sorry I meant to ask if you wrote the web application yourself?

[vishnu01445]

no...i am a end user of the application.

[VBee]

Well I dont think VBA will offer a solution here as the problem occurs before you even open the excel file.
I think the problem might lie with the web application. It's not providing the MIME type to your web browser when downloading.

You can either seek support from the web application or if you're using a large number of excel files, you can download them all to a specific location and use a script to change all extensions to ".xls" etc.

[vishnu01445]

ok,,thanks for your help.

[vishnu01445]

Hello All,

Can i expect any help from anyone???

Thanks,
Vishnu

[vishnu01445]

Can anyone answer to my question, as i am searching for answer from last 15days....Plz......

[Kyle123]

Hasn't VBee answered your question?

[vishnu01445]

Hello,

No, he hasnot answered my question.

Thanks,

[Kyle123]

Well what else do you want to know, it looks like he has answered it?

[vishnu01445]

He suggested that to change the web application. but it is not possible from my end, as i am an endu user.

[vishnu01445]

Hello All...

Thanks to everyone. i got the answer.

I wrote the code and put in addin for save the file.now i can download the excel(with .htm extension) from web application and able to run the macro to save the file.

Thanks & Regards,
Vishnu

[Cutter]

@ vishnu01445

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.