I wish to save a worksheet as an HTM file for email purposes.
Is this possible in VBA code?

Sure. There is no built-in functionality for that, but there’s no difficulty in writhing a routine that selectively reads data from the worksheet, then writing it to a file, adding the necessary HTML elements to format the info.

Also, Excel does have the ability to save a worksheet as HTML . . . (Contained in the Save dialog.)

Thanks for the reply. Is it not possible to automate the same function as the excel save dialogue box within VBA code?

I really did not want to mess about with HTML syntax.

Virtually anything you can do with the menu system can also be done with VBA.

I think you will have to create a User Form and put a common dialogs control on it.

In setting up the displaying of the Save / SaveAs dialog, add *.htm to the filter list.

Once the user has made their choices, use VBA to save the worksheet accordingly.

For me, recording a macro yielded the following:         Actually, in looking, I don’t see the CommonDialogs control. I’m sure that there is a standard way in Excel to show the various dialogs. I am just not sure what that is.

But once you have the filename to save to and the location, you can use the .SaveAs method of the workbook to do the actual work.