Is It Possible To Create An IE Page Using VBA?

[nevi]

Hey Everyone!

Is it possible to create an IE page using VBA? My overall project is much more complex than this, but for the sake of simplicity, have a look at the example below:

Please Login or Register  to view this content.

Now, obviously there is a ton more code, etc above and below this but none of it is relevant to my question.

What I am wondering is if there is a way to now open an IE Window that displays the contents of my Body string?

Thanks a million for your help!!

[nevi]

Hey Everyone,

So, been up all night Googling this and reading through forum after forum and come up with ziltch - I don't think this is possible. So - does anyone have a suggestion of how else I could accomplish this?

Let me explain the end goal in a little more detail. Basically, this vba script opens a large user input with a few hundred different fields. Based on the user's input, the fields move and change, look up data from the other sheets in the book, etc. At the bottom of the form is a Command Button that takes all the information captured in the form and puts it into a new email - hence the HTML tagging that is currently captured in the Body string. Now, the issue I am facing is that when my user base is working out of OWA instead of Outlook (which is more common then I realized) then they are not able to use this tool. No Outlook means no email opens. So, what I am trying to do is add a second button at the bottom that will open the email text in a different media, such as IE.

If I could get it to open in an HTML Document or a Word Document, that would be fine. Even a big message box would be fine. It just needs to be something that will read the HTML and format/line break accordingly, instead of displaying the tags as part of the text. It also needs to display in a way that the text can be easily copy/pasted. Idea being, the users working in OWA would manually open a new email, generate the template using this tool, then copy/paste the results into that new email.

Any help is greatly appreciated. I am at a loss on how to accomplish this...

[ragulduy]

Please Login or Register  to view this content.

That should work I think. Change path to somewhere you have access to on your drive and is unlikely to be an existing file as it will be overwritten.

[jonboy6257]

Would it be simpler just to create a form (containing all the options) and have it add and entry to a DB with the user options they chose (after all options have been chosen)?

[nevi]

This works great except for one thing: the oFile.Close and oFile.Delete commands cause the file to open and then immediately close - you never actually see it. However, overwriting the file over and over does not seem to cause any errors, even if the file is already open, so I just removed those two lines and viola - it works like a charm.

Thank you soooo much - I really, really appreciate it!!