exporting data from My Excel to my Web

S

Sam

Let's say if i have the following data in my Excel sheet:

Employee # Name phone#
----------------------------------------
1 John 111
2 Brian 222
3 cindy 333

And I have a secured website that I want to enter information to it without
fat finguring the information again for example phone # see below:

From my secured autherized website:
Employee # Name phone#
----------------------------------------------------------------
1 John to import john data from my excel sheet ...
2 Brian to import it Brian data from my excel
sheet ...
3 cindy to import cindy's data from my excel
sheet...

Is there a way to import phone # (for example) of the people automatically
from my Excel sheet without fat finguring the information that I have already
entered in my excel sheet?

Thank you
Sam :=)
 
R

ryguy7272

Yes, sure, more information is required though. What is the web site? Also,
you have to set up a loop. Are you good with loops?

Ryan---
 
S

Sam

It is a scure site that I have to log in (univeristy site). After I log in
to the site and then I go to enter the grades.
All of my students grades are already entered in my spreadsheet and would
like to have them automatically submitted to the website. I am not sure if I
made it clear before.

I have copied some of the lines from the source document fromexplorer. not
sure if this will help? Here it is:


<tr class="entergrade_tr">
<td width="10%" colspan="3" align="left">
<span class="no_wrap">
<input type="hidden" id="commentText_9022504006"
name="commentText_9022504006" value=""/>
<a onclick="isWithinPage();"
target="_blank"
href="postAttachments.do?irn=9022504006&subject=MAT%2F116+%2F+Week+5+%2F+Discussion+Questions&courseOfferingId=18666076">Cindy Coop</a>


Thank you so much for your help. I really really apreciate your reply.
 
R

ryguy7272

Ok, no guarantees that this will work, but it will definitely get you going
in the right direction:
Sub kk()
ActiveWorkbook.FollowHyperlink Address:="
http://xxxxxyour-web-site-herexxxxx", NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
' Application.SendKeys ("{%TAB}")
Module2.Macro1
Application.SendKeys ("%{TAB}")
Application.SendKeys (Cells(1, 2).Value)
Application.SendKeys ("{TAB}")
Application.SendKeys (Cells(2, 2).Value)
Application.SendKeys ("~")
End Sub

Module2:
Sub Macro1()
Dim r As Integer
For r = 1 To 10
Cells(2, 4).Value = Time
Cells(3, 4).Value = r
Application.Wait (Now + TimeValue("00:00:01"))
Next r
End Sub

Put your username in Cell B1 and your password in Cell B2.

That MIGHT work. I had a similar issue recently. The import process never
worked; never really got it straightened out,...but I did successfully log
into the web site using the code above.

Anyway, login and they you can call another macro to do the web import.

Good luck,
Ryan---
 
S

Sam

You are a life saver... thank you so much, I did little modification and it
did work. Thank you. But do you know why sometimes ("%{TAB}") works and
sometimes it doens't focus even though I try it manually before I execute the
macro but then when I execute the macro ("%{TAB}") doesn't work all the time,
sometimes it does focus and sometime it doesn't. one thing I realize though
is that the numlock key is turning off everytime this commnad executed. I
tried it without the first bracket
"%{TAB}" , it didn't to make it to focus all the time.

thoughts?
thank you again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top