• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

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';return true;" title='OdenPT'><U>A</U>ccept 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
0
Sandesh555
Asked:
Sandesh555
  • 7
  • 5
1 Solution
 
khairilCommented:
Hi,

Where really the Excel is?
0
 
Sandesh555Author Commented:
Hi,

I am trying to connect Excel with a Webpage.
0
 
Sandesh555Author Commented:
The Excel is running on my Desktop...
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Sandesh555Author Commented:
Can someone please asnwer my question.
0
 
NorieCommented:
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.
0
 
Sandesh555Author Commented:
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.
0
 
NorieCommented:
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.
0
 
Sandesh555Author Commented:
How do i do that... Can you please provide me a sample coding for testing.  I have a good understanding of development.
0
 
NorieCommented:
Do what?
0
 
Sandesh555Author Commented:
How to automate data entry from Excel to a Website with Frames.
0
 
NorieCommented:
This is a small example where the page has 2 frames.

All it does is grab references to both frames.
Option Explicit

Sub test()
Dim IE As Object
Dim doc As Object
Dim frm1 As Object
Dim frm2 As Object
Dim baseURL As String

    baseURL = "http://localhost/"

    Set IE = CreateObject("InternetExplorer.Application")

    IE.navigate baseURL & "FrameTest.html"
    'wait for page to load
    Do Until IE.ReadyState = 4
        DoEvents
    Loop

    IE.Visible = True

    Set doc = IE.Document

    Set frm1 = doc.frames(0).Document ' set reference to 1st frame on page
    Set frm2 = doc.frames(1).Document ' set reference to 2nd frame on page

    Set IE = Nothing
End Sub

Open in new window


What is it you actually want to do?

You've mentioned Excel and Data Entry a few times but you don't give any details.
0
 
Sandesh555Author Commented:
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.
0
 
NorieCommented:
I realise it's a confidential site, and I wouldn't expect you to share the details.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now