I am trying to get my VBA in Access to open a .htm file in IE and then save the source code so I can add it to the body of an email.
I can get IE to open and navigate to the file (see code snippet), but this is as far as I can get.
I need the code to be able to view / save the underlying HTML Code for this file.
Dim ieApp as Object
Set ieApp = CreateObject("internetexplorer.application")
ieApp.Visible = True