I would like to create a click button on Userform that allows user to do "save as" the data sheet with certain cells and in .mhtml format.
I have tried code shown below but it's not working. please if anybody could help for this. Thanks.
Please Login or Register to view this content.
Last edited by copythat; 10-30-2011 at 02:15 PM.
SaveAs is a method of Workbook an Worksheet, but not Range. You cannot save a range as a file.
Also, Excel does not provide native support for MHTML. You can specify a format of HTML.
6StringJazzer, thank you very much
I would like to ask a little bit more. Now I try a new code (shown below) to export the file as .html. My problem is the data is not exported properly. Web browser can't read it and I need the export file to contain formatting and colors as shown in excel. If it's possible?
Please Login or Register to view this content.
Last edited by copythat; 10-29-2011 at 08:45 PM.
It would serve you to record yourself doing an actual SAVEAS HTML and then work with adapting the resulting code. Saving to HTML is an entirely different syntax.
That should get you started experimenting with the various parameters.Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you very much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks