VBA to notepad (.html) UTF-8 is this possible?

I have had experience with copying excel data to word with a macro, and saving as HTML format. But now I would like to do the following:
Can VBA open an existing notepad file, clear all text and paste values from worksheet, then save and close the notepad file?
I can't seem to find how to do this, so I have been going down the road of trying to open a new notepad file, pasting from worksheet and saving over using .html prefix, however I cannot find the right code to do this, as it would also need to be saved with UTF-8 encryption.

Any help would be greatly appreciated
P

Please Login or Register  to view this content.

But All i get is gibberish when opening using a web browser - this is becasue of Words auto html format which is not what i want so i decided to go with notepad

P

Or can i save to natepad as html without the UTF encryption?

P