Copy Excel data to web page

[marktimm22]

Excel 2003, Windows XP:

I have 10 columns of address information in Excel. I need to copy the contacts of the columns into a web page that I have no control over. (I can not change the page) In other words, I am filling out a web form with the contents of row 2, hitting accept, then filling out the web page with row 3, etc...

Can this be done with Excel, or do I need to get another product/device?

Thanks!!!

 

[dscheste]

Thanks, eh? That's what I call polish. Respect.

 

[NateO]

You're welcome eh?

Another thing. Tab within your code. I had to work (and I'm lazy!) far too hard to see what you were doing... Formatted code would have helped me significantly!

My code wasn't flat, how did your's end up that way?

 

[dscheste]

My code wasn't flat, how did your's end up that way?

I do not really know, guess it happened when I copied the code to with it. I then rearranged it several times. Usually I use tabs to draw structure and lot of comments.

'Ppreciate headsup on the codeflow, eh

 

[cav609]

Nate

Great piece of code.

Have used it now on a number of sites .. BUT ... have now encountered a site where the username button is called "username". This is a VBA property and as a consequence the macro halts?

 

[NateO]

Thanks,

It's not quite as good as this:

http://www.mrexcel.com/board2/viewtopic.php?p=884522#884522



But back to your problem... That's not the only potential problem, the control's name might have a space in it, encountered this with Hotmail...

When you say button, did you mean Button or Textbox? If it's a matter of submitting the form see #4 here:

http://www.mrexcel.com/board2/viewtopic.php?p=521677#521677

If it's a textbox, which was the case with Hotmail, I worked around it by looping through the controls...

 

[cav609]

whoops!!

Username
<input type="text" name="username" class="inputbox" size="10" />

Password
<input type="password" name="passwd" class="inputbox" size="10" />

<input type="hidden" name="op2" value="login" />
<input type="hidden" name="lang" value="english" />
<input type="hidden" name="return" value="/cms/" />
<input type="checkbox" name="remember" class="inputbox" value="yes" /> Remember me

<input type="submit" name="Submit" class="button" value="Login" />

 

[cav609]

double whoops - HTML doesnt seem to want to turn off

anyway the code says

Username input type equals text name equals username class equals inputbox

regards

cav

 

[cav609]

Assume that the above presents the same issues as you encountered with hotmail. If so, how do you go about looping through the controls?

cav

 

[NateO]

Hello,

You need to disable HTML and place the source in code or pre tags, e.g.,

Username
<input type="text" name="username" class="inputbox" size="10" />

		Password
<input type="password" name="passwd" class="inputbox" size="10" />

		<input type="hidden" name="op2" value="login" />
		<input type="hidden" name="lang" value="english" />
		<input type="hidden" name="return" value="/cms/" />
		<input type="checkbox" name="remember" class="inputbox" value="yes" /> Remember me

		<input type="submit" name="Submit" class="button" value="Login" />

This does not have the same problem. The 1st is 'username', the 2nd one is 'passwd', the 3rd is 'return', the 4th is 'remeber', the 5th is 'Submit'.

Does this help? Are your saying ie.document.forms(x).UserName.Value doesn't work? Because I suspect it does... Do you have any source code?