Updating Html Forms With Textboxes

Re: Updating Html Forms With Textboxes

[COLOR="Navy"]Maybe. I'm not clear what you mean when you say, "textboxes within excel". By textbox, do you just mean a cell (like A1) or did someone actually use the form tools to add a textbox form element (edit box) to an Excel file?

If you are just talking about cells then perhaps you can do it, depending on the structure of how your web site works. You can build hyperlinks in Excel that can post data. For example, look at the address bar in your browser now. You will see something like, "[SIZE="2"][FONT="Courier New"]http://www.ozgrid.com/forum/ne…wreply&noquote=1&p=302240[/FONT][/SIZE]". Everything after the question mark is data that was posted to this web page.

Say for example you had the following:
[FONT="Courier New"][SIZE="2"] Cell A1 contains: http://www.ozgrid.com/forum/newreply.php
Cell A2 contains: do
Cell B2 contains: newreply
Cell A3 contains: noquote
Cell B3 contains: 2
Cell A4 contains: p
Cell B4 contains: 302240[/SIZE][/FONT]

Then in cell A5, you put the following hyperlink formula:
[SIZE="2"][FONT="Courier New"] =HYPERLINK(A1&"?"&A2&"="&B2&"&"&A3&"="&B3&"&"&A4&"="&B4,"Post to web")[/FONT][/SIZE]

Build the worksheet as I have shown above. Then click on the hyperlink that you built in cell A5. Voila! Your browswer will open to this post with the reply text box prefilled with a quote of your post.

This isn't really a very good example, but it gives you an idea. If your intranet site is constructed such that the form fields on the page will "request" and fill out textareas with data from the address string then you are in luck. OR if you can look at the URL in the address bar, after you have submitted the form, and break the URL apart into meaningful sections the you might also still be in luck.

So good luck,
Andrew[/COLOR]