Form that creates a pre-made web page

[VegasNath]

A long time ago, I wrote an HTML application (.hta, which runs only in IE) which would create a new HTML signature file for Outlook users based on a form they filled out. This was done with VBScript, which is a venerable (okay, "obsolete") proprietary language that someone in your organization might know. (I might be able to dredge it up as a code sample. Not sure where it is now.)

== Edit ==

Here is the application I mentioned, with a few changes to generalize the contact information. If you double-click the .hta, it should launch in IE, although there might be security issues in IE8 (I didn't test). To edit it, open in Wordpad or your favorite HTML editor.

[attachment=87363:SigMaker-SAMPLE.zip]

Thanks a lot for sharing this Jefferson. I'm hoping to learn lots from playing around with this.

[handyandy]

It is standard VBA but uses the Forms objects in the Editor. If you are totally new to the Excel environment, yes it will be a little more difficult but the underlying code hasn't changed (much) it just references objects on the form rather than on the worksheet. What would you like to customise?

I believe I will be able to figure the coding out for the most part to customize it, I just need to find the time to learn it.
One thing I know I will want to do in the form was mentioned in a previous post that can be found here: http://bro.ws/769717L

I have been following this thread with interest, and really like Jezza's latest offering of an excel user form. I have sliced and diced it (for my own educational purposes) and understand the set-up entirely. Thanks for the lesson!
I am interested to know whether this could be achieved in a stand alone application, outside of excel? If so, if anybody could provide a simple example file so that I can continue my new year education.

I am glad this thread has brought interest to you. I am also interested in having a form like this in a stand alone application too, but I think I will settle for having it work inside of excel because I believe it will be easier to customize.

Thanks a lot for sharing this Jefferson. I'm hoping to learn lots from playing around with this.

I played around with the form that Jefferson created, and I like his as well. Can't I just delete the scripting to that and insert the scripting that Jezza used. This way it will work without the need for excel. Please let me know, and thanks for the info I wasn't aware that Jefferson had edited his last post and attached a sample.

[VegasNath]

I played around with the form that Jefferson created, and I like his as well. Can't I just delete the scripting to that and insert the scripting that Jezza used. This way it will work without the need for excel. Please let me know, and thanks for the info I wasn't aware that Jefferson had edited his last post and attached a sample.

I am almost certain that the vba code from Jezza's userform could be incorporated into a HTML application (like the one Jefferson posted), or something similar. I am playing as we speek, so will keep you posted. If I am wrong, I hope a more experienced lounger will jump in and save me the pain of being proven wrong.

OTOH, I'm not sure whether the "maximum string length" requirement could be incorporated?

[handyandy]

Thanks,
Your "OTOH" is a perfect example, or reason why this has been making me crazy from bouncing all over deciding what route to go with. I mean I want features "A, B, and C", but if I use "Program 1" which is only compatible with "scripting code X", then I can only have features "A and B".
Fairly often when dealing with computers it can be hard to know where to start or who to ask for help because of this.

[VegasNath]

No success thus far, but I'll keep plugging away when I have time spare. I'm on a spring clean manic mission currently, but i'll have another play later.

.hta appears to be somewhat outdated, but still possibly adequate I did rather a lot of reading last night on the subject and was viewing online .hta examples (google it). Some interesting stuff, all of which is new to me!

[handyandy]

Thanks for the update, I have been busy lately with some other stuff,
so I didn't get around to "playing" with the code or learn about .hta files.

[handyandy]

Hello,
I am trying to take Jezza's visual basic coding from the excel file and create an .exe file using visual basic.
I don't know if I can do this, but I assume that since they both use visual basic, that it could be possible.
Any help would be great. Thanks.

[Jezza]

Hello,
I am trying to take Jezza's visual basic coding from the excel file and create an .exe file using visual basic.
I don't know if I can do this, but I assume that since they both use visual basic, that it could be possible.
Any help would be great. Thanks.

Andy, I am happy to help but it is difficult without knowing roughly what you want exactly as my first offerings were Proof of Concept. How about sending us what you have or code snippets that we can get our teeth into.

If it is application specific we can move it to that relevant board as we can tap into more expertise in that area. Don't worry about the standard of your code us regulars are very forgiving.

[handyandy]

I really just wanted to make the form you made in excel work without needing excel.
Like a standalone .exe program. I understand the visual basic code, but I am new to Microsoft Visual Basic,
and I just wanted to copy your code and paste it into Visual Basic.
And then I would change the code to my liking.

[VegasNath]

Hi Andy,

I am going to need to take a back seat on this one I'm afraid as my experience in insufficient in this area. I am hoping that Jerry or another lounger will be able to assist you, I will be looking on and hoping to learn from it as I am very interested in this type of thing. I just never know where to start.....

Goog Luck

Nathan

[handyandy]

Thanks, I am hoping too....

[handyandy]

I downloaded Microsoft Visual Basic 2008 Express Edition. I am trying to input Jezza's coding into it, but I am having 2 problems:
1) I don't know how to view Jezza's Code from Microsoft Excel.
2) I don't know where to paste Jezza's Code into Microsoft Visual Basic 2008 Express Edition to make it into an .exe program.
Jezza's Excel file that I am referring to can be found here: createHTMLv4

Any help on this would be greatly appreciated.
Thanks,
HandyAndy

[jscher2000]

I downloaded Microsoft Visual Basic 2008 Express Edition. I am trying to input Jezza's coding into it, but I am having 2 problems...

This seems to have changed from a web development question to a Visual Basic question. Also, I can't find Jezza's XLS file in this thread. If you wish to pursue this question, I suggest starting a new thread with all the relevant (but none of the irrelevant) information on the Windows Programming forum.