Whether it's a Windows Script file or a VBA script inside an application, scripting provides the ability to add functionality to applications....
Using the approach below, you can use Word, Access or Excel to read HTML documents on the web, alter those documents, and then output whatever you want in a new browser window.
This is what that looks like: This is a very basic example of what this is capable of. He's worked 13 years in automation engineering, 5 years in IT, and now is an Apps Engineer.
It may sound like something that only an experienced VBA programmer can do, but in this article I’m going to show you how you can do this yourself, starting with a basic procedure to output data from within your own application to a webpage.
The first step, no matter how you want to make use of the ability to input/output your own HTML via VBA, is to enable the Microsoft Internet Controls reference.
What I’ve done here is used the IE object to read HTML from Google into a text variable in VBA called HTML.
I then placed my own HTML output text in the top of the page, and then outputted the same HTML to the VBA HTML output.
In fact, thanks to the embedded references in applications that use VBA, you can input and output webpages via your own applications.