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?
Bookmarks