Sandesh555
asked on
Excel to Web Automation of frames
Hi Team,
I have done some basic automation in Internet Explorer. but I have hit a road block.
I have a website. In which the source code different in each part of the page. Basically if I select the central part of the page, I get a differnt source code and when I select the left side of the page I get a different source code.
Now the Hyperlink that I what to click on has the Name "35" and is found in the left side of the page. Here is the copy of the same.
<a name=35 class=menuButton href="javascript:f65();" onmouseover="window.status ='OdenPT ShortCut=Alt-A';return true;" onmouseout="window.status= 'Ready';re turn true;" title='OdenPT'><U>A</U>cce pt Disclaimer</a>
How do I automate this.
I have attached both the source codes for your reference. Left-Side-Source-Code.txt Left-Side-Source-Code.txt Centre-Side-Source-Code.txt Left-Side-Source-Code.txt
I have done some basic automation in Internet Explorer. but I have hit a road block.
I have a website. In which the source code different in each part of the page. Basically if I select the central part of the page, I get a differnt source code and when I select the left side of the page I get a different source code.
Now the Hyperlink that I what to click on has the Name "35" and is found in the left side of the page. Here is the copy of the same.
<a name=35 class=menuButton href="javascript:f65();" onmouseover="window.status
How do I automate this.
I have attached both the source codes for your reference. Left-Side-Source-Code.txt Left-Side-Source-Code.txt Centre-Side-Source-Code.txt Left-Side-Source-Code.txt
ASKER
Hi,
I am trying to connect Excel with a Webpage.
I am trying to connect Excel with a Webpage.
ASKER
The Excel is running on my Desktop...
ASKER
Can someone please asnwer my question.
Where's the source code of the page?
If you want the link is in the left frame that's what you should be working with.
If you want the link is in the left frame that's what you should be working with.
ASKER
Hi,
I have attached the source code of the page in the question. You will be four attachments in .txt file format and yes the link that I want to click is in the left frame of the page.
Please note that file "Left-Side-Source-Code.txt " was to be attached only one. But some how the file got attached three times. So please ignore the other two additinal .txt files.
I have attached the source code of the page in the question. You will be four attachments in .txt file format and yes the link that I want to click is in the left frame of the page.
Please note that file "Left-Side-Source-Code.txt
That isn't the source code of the page the frames are on, it's the source code of the frames themselves.
The code of a page with frames on it looks a little like this extremely simple example:
<frameset cols="25%,75%">
<frame src="frame_a.htm" />
<frame src="frame_b.htm" />
</frameset>
That's the part you need to get a reference to the frame you want.
The code of a page with frames on it looks a little like this extremely simple example:
<frameset cols="25%,75%">
<frame src="frame_a.htm" />
<frame src="frame_b.htm" />
</frameset>
That's the part you need to get a reference to the frame you want.
ASKER
How do i do that... Can you please provide me a sample coding for testing. I have a good understanding of development.
Do what?
ASKER
How to automate data entry from Excel to a Website with Frames.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think the given above code should help me. Will post back after doing some testing.
Regarding giving more details, I am really sorry here. As the web page is a confidential side. I will not be confortable to share more details on a public form as such.
Regarding giving more details, I am really sorry here. As the web page is a confidential side. I will not be confortable to share more details on a public form as such.
I realise it's a confidential site, and I wouldn't expect you to share the details.
Where really the Excel is?