Hello,

First post and I'm trying to see if my task is even possible with minor VBA skills. Currently, we have a vendor that sends a list of machine setpoint changes every night in an email. It comes as an .MHTML file extension attachment. I have a script working to save the attachment to a folder on the network when the email arrives. The attachment is sent with the same name each night so the script assigns an identifier to the end of the name:

MachineEventsCustom(1).mhtml
MachineEventsCustom(2).mhtml
etc.

The next step would be to export the table from the MHTML file to a more usable file format like .xlsx.

I have been trying to use the google machine but don't even know where to begin on this.

Help?