Get address from iFrame reference in page source
 

Hello!

I know this is not directly related to Excel programming, but I am
building a macro to download a report from our online tool into Excel.

The web address string is always the same except for the session ID
and the RequestGUID, but the address is the only place that I see it
referenced. Is there any way to extract that from the following
address into a macro variable?

<iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:parameters=false&RequestGUID=**GU IDHERE**&rc:toolbar=true"


Thanks for your help!



Steven

Get address from iFrame reference in page source
 

See if this helps


First example I boke you long string into several lines by using the & and
continuation character (_)

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
"rs:Command=Render&" & _
"SessionID=**SESSIONIDHERE**&" & _
"rc:parameters=false&" & _
"RequestGUID=**GUIDHERE**&" & _
"rc:toolbar=true"

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
DoEvents
Loop

end sub
---------------------------------------------------------------------------------------
Now I broke the command up to serveral variables

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

CommandString = "rs:Command=Render&"
SessionString = "SessionID=**SESSIONIDHERE**&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
CommandString & _
SessionString & _
ParameterString & _
GuideString & _
ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
DoEvents
Loop

end sub
---------------------------------------------------------------------------------------
Finally I made the SessionID a varialbe

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

SessionID = "**SESSIONIDHERE**"

CommandString = "rs:Command=Render&"
SessionString = "SessionID=" & SessionID & "&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
CommandString & _
SessionString & _
ParameterString & _
GuideString & _
ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
DoEvents
Loop

end sub

" wrote:

Hello!

I know this is not directly related to Excel programming, but I am
building a macro to download a report from our online tool into Excel.

The web address string is always the same except for the session ID
and the RequestGUID, but the address is the only place that I see it
referenced. Is there any way to extract that from the following
address into a macro variable?

<iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:parameters=false&RequestGUID=**GU IDHERE**&rc:toolbar=true"


Thanks for your help!



Steven

Get address from iFrame reference in page source
 

On Sep 11, 3:57*pm, Joel wrote:
See if this helps

First example I boke you long string into several lines by using the & and
continuation character (_)

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
* * * * * "rs:Command=Render&" & _
* * * * * "SessionID=**SESSIONIDHERE**&" & _
* * * * * "rc:parameters=false&" & _
* * * * * "RequestGUID=**GUIDHERE**&" & _
* * * * * "rc:toolbar=true"

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
* *DoEvents
Loop

end sub
--------------------------------------------------------------------------- ------------
Now I broke the command up to serveral variables

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

CommandString = "rs:Command=Render&"
SessionString = "SessionID=**SESSIONIDHERE**&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
* * * * * CommandString & _
* * * * * SessionString & _
* * * * * ParameterString & _
* * * * * GuideString & _
* * * * * ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
* *DoEvents
Loop

end sub
--------------------------------------------------------------------------- ------------
Finally I made the SessionID a varialbe

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

SessionID = "**SESSIONIDHERE**"

CommandString = "rs:Command=Render&"
SessionString = "SessionID=" & SessionID & "&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
* * * * * CommandString & _
* * * * * SessionString & _
* * * * * ParameterString & _
* * * * * GuideString & _
* * * * * ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
* *DoEvents
Loop

end sub

" wrote:
Hello!

I know this is not directly related to Excel programming, but I am
building a macro to download a report from our online tool into Excel.

The web address string is always the same except for the session ID
and the RequestGUID, but the address is the only place that I see it
referenced. Is there any way to extract that from the following
address into a macro variable?

<iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:paramete rs=false&RequestGUID=**GUIDHERE**&rc:toolbar=true"

Thanks for your help!

Steven

Hi Joel:

The code looks good for rendering it, my biggest challenge though is
extracting the SessionID and RequestGUID from the page source. It
appears in a segment "<iframe src=", followed by the url you
dissected. Do you know how to call on the page source and look for
that?

Actually, if that can be extracted, then the entire URL could be,
which would probably be more effective.

Nearly there.


Steven

Get address from iFrame reference in page source
 

On Sep 11, 6:38*pm, wrote:
On Sep 11, 3:57*pm, Joel wrote:



See if this helps

First example I boke you long string into several lines by using the & and
continuation character (_)

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
* * * * * "rs:Command=Render&" & _
* * * * * "SessionID=**SESSIONIDHERE**&" & _
* * * * * "rc:parameters=false&" & _
* * * * * "RequestGUID=**GUIDHERE**&" & _
* * * * * "rc:toolbar=true"

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
* *DoEvents
Loop

end sub
--------------------------------------------------------------------------- ------------
Now I broke the command up to serveral variables

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

CommandString = "rs:Command=Render&"
SessionString = "SessionID=**SESSIONIDHERE**&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
* * * * * CommandString & _
* * * * * SessionString & _
* * * * * ParameterString & _
* * * * * GuideString & _
* * * * * ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
* *DoEvents
Loop

end sub
--------------------------------------------------------------------------- ------------
Finally I made the SessionID a varialbe

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

SessionID = "**SESSIONIDHERE**"

CommandString = "rs:Command=Render&"
SessionString = "SessionID=" & SessionID & "&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
* * * * * CommandString & _
* * * * * SessionString & _
* * * * * ParameterString & _
* * * * * GuideString & _
* * * * * ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
* *DoEvents
Loop

end sub

" wrote:
Hello!

I know this is not directly related to Excel programming, but I am
building a macro to download a report from our online tool into Excel..

The web address string is always the same except for the session ID
and the RequestGUID, but the address is the only place that I see it
referenced. Is there any way to extract that from the following
address into a macro variable?

<iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:paramete rs=false&RequestGUID=**GUIDHERE**&rc:toolbar=true"

Thanks for your help!

Steven

Hi Joel:

The code looks good for rendering it, my biggest challenge though is
extracting the SessionID and RequestGUID from the page source. It
appears in a segment "<iframe src=", followed by the url you
dissected. Do you know how to call on the page source and look for
that?

Actually, if that can be extracted, then the entire URL could be,
which would probably be more effective.

Nearly there.

Steven

Wow, I don't think I could have been more unclear than these couple of
posts.

Let's try this again.

1. I have created a macro that navigates through an series of online
forms that lead to a report I need to download

2. The generated report is contained in an iFrame and I cannot figure
out how to send commands to the objects or fields within the iFrame

3. When I extract (manually) the iFrame page address from the page
source and navigate to it, I can send commands to the page.

I'm not sure what the best approach to this is, but I am imagining
that I call on the page source with code, search for the "<iframe
src="and extract the address from there.

My question - how do I access the page source using code to get that
address? Here's the example


<iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:parameters=false&RequestGUID=**GU IDHERE**&rc:toolbar=true"


Steven

Get address from iFrame reference in page source
 

I'm can interpret your question too many ways.

1) Do you already have the string?

MyString = <iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:parameters=false&RequestGUID=**GU IDHERE**&rc:toolbar=true"

then you just need to remove the charaters before the equal sign and send a
web request like this

Request = mid(MyString,instr(MyString,"=")+1
'Note if the string contains the double quotes they also have to be removed
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

'get web page
IE.Navigate2 Request
Do While IE.readyState < 4
DoEvents
Loop

2) Or do you already have an Internet object and are try to find the tag
item "iframe". Tags start with <iframe and end with /iframe or / . The
tag name is not necesssary and the en d of the tag but is nicer to have to
make the code more readible.

set MyTag = IE.document.getelementsbytagname("iframe")

this will get all the iframe items. You may have to look through each one
to find the correct one.

for each itm in Mytag
if itm.ClassName = "xyz" then

end if

next itm



3) Another trick is search for id="abc" on the internet object

Set PageNumber = IE.document.getElementById("abc")



4) When all fails

RowCount = 1
for each itm in IE.Document.All
Range("A" & RowCount) = itm.classname
Range("B" & RowCount) = left(itm.innertext,256) 'this is very long an
can cause memory errors
Range("C" & RowCount) = itm.tagname

RowCount = RowCount + 1
next itm




" wrote:

On Sep 11, 6:38 pm, wrote:
On Sep 11, 3:57 pm, Joel wrote:



See if this helps

First example I boke you long string into several lines by using the & and
continuation character (_)

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
"rs:Command=Render&" & _
"SessionID=**SESSIONIDHERE**&" & _
"rc:parameters=false&" & _
"RequestGUID=**GUIDHERE**&" & _
"rc:toolbar=true"

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
DoEvents
Loop

end sub
--------------------------------------------------------------------------- ------------
Now I broke the command up to serveral variables

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

CommandString = "rs:Command=Render&"
SessionString = "SessionID=**SESSIONIDHERE**&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
CommandString & _
SessionString & _
ParameterString & _
GuideString & _
ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
DoEvents
Loop

end sub
--------------------------------------------------------------------------- ------------
Finally I made the SessionID a varialbe

Sub Report()

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

SessionID = "**SESSIONIDHERE**"

CommandString = "rs:Command=Render&"
SessionString = "SessionID=" & SessionID & "&"
ParameterString = "rc:parameters=false&"
GuideString = "RequestGUID=**GUIDHERE**&"
ToolbarString = "rc:toolbar=true"

URL = "https://reports.e2rm.com/ReportServer"
Request = "?/e2RM/Reports/CustomKFCDonation&" & _
CommandString & _
SessionString & _
ParameterString & _
GuideString & _
ToolbarString

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState < 4
DoEvents
Loop

end sub

" wrote:
Hello!

I know this is not directly related to Excel programming, but I am
building a macro to download a report from our online tool into Excel..

The web address string is always the same except for the session ID
and the RequestGUID, but the address is the only place that I see it
referenced. Is there any way to extract that from the following
address into a macro variable?

<iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:paramete rs=false&RequestGUID=**GUIDHERE**&rc:toolbar=true"

Thanks for your help!

Steven

Hi Joel:

The code looks good for rendering it, my biggest challenge though is
extracting the SessionID and RequestGUID from the page source. It
appears in a segment "<iframe src=", followed by the url you
dissected. Do you know how to call on the page source and look for
that?

Actually, if that can be extracted, then the entire URL could be,
which would probably be more effective.

Nearly there.

Steven

Wow, I don't think I could have been more unclear than these couple of
posts.

Let's try this again.

1. I have created a macro that navigates through an series of online
forms that lead to a report I need to download

2. The generated report is contained in an iFrame and I cannot figure
out how to send commands to the objects or fields within the iFrame

3. When I extract (manually) the iFrame page address from the page
source and navigate to it, I can send commands to the page.

I'm not sure what the best approach to this is, but I am imagining
that I call on the page source with code, search for the "<iframe
src="and extract the address from there.

My question - how do I access the page source using code to get that
address? Here's the example


<iframe src="https://reports.e2rm.com/ReportServer?/e2RM/Reports/
CustomKFCDonation&rs:Command=Render&SessionID=**SE SSIONIDHERE**&rc:parameters=false&RequestGUID=**GU IDHERE**&rc:toolbar=true"


Steven

Get address from iFrame reference in page source
 

Hi Joel:

Method 2 finds the IFRAME tag, but I still can't figure out how to
grab the address. I've been digging through documentation online, but
I don't know how to phrase my question correctly for this. The site I
am navigating through is a database for our online donations.
Currently I log in, run a report and request the report in Excel
format. The fields and buttons I manipulate in order to export the
data to Excel format are all contained in an iFrame and I can't access
any of the objects.

I am trying to open the iFrame address using code and the only place I
can find it is in the page source. ViewSource

That's the string I provided at the beginning.

Once I've got that string, I want to extract the sessionID and GUID
which I can use in another string to force the export to an Excel
file.

Does that help?


Steven


2) Or do you already have an Internet object and are try to find the tag
item "iframe". *Tags start with <iframeand end with * */iframe *or / . The
tag name is not necesssary and the en d of the tag but is nicer to have to
make the code more readible.

set MyTag = IE.document.getelementsbytagname("iframe")

this will get all theiframeitems. *You may have to look through each one
to find the correct one.

for each itm in Mytag
* *if itm.ClassName = "xyz" then

* *end if

next itm

Get address from iFrame reference in page source
 

The address is probably in the string : MyTag.innertext.

set MyTag = IE.document.getelementsbytagname("iframe")

There are a few things to try

1) Put a break point on the line below the set Mytag by clicking on the line
and then pressing F9. Run the code until the break point. Then add watch
variable by highlighting with the mouse Mytag and right click mouse. select
Add watrch and then press OK on pop-up window. then open the Watch variable
by clicking on the (+) plus sign. My tag will be multiple items so you may
have to open each of the items in the watch window. See if you find the
address

2) try this testt code
set MyTag = IE.document.getelementsbytagname("iframe")
for each itm in MyTag
if instr(itm.innertext,"enter the address here") 0 then
msgbox("Found Address")
next itm
next itm


" wrote:

Hi Joel:

Method 2 finds the IFRAME tag, but I still can't figure out how to
grab the address. I've been digging through documentation online, but
I don't know how to phrase my question correctly for this. The site I
am navigating through is a database for our online donations.
Currently I log in, run a report and request the report in Excel
format. The fields and buttons I manipulate in order to export the
data to Excel format are all contained in an iFrame and I can't access
any of the objects.

I am trying to open the iFrame address using code and the only place I
can find it is in the page source. ViewSource

That's the string I provided at the beginning.

Once I've got that string, I want to extract the sessionID and GUID
which I can use in another string to force the export to an Excel
file.

Does that help?


Steven


2) Or do you already have an Internet object and are try to find the tag
item "iframe". Tags start with <iframeand end with /iframe or / . The
tag name is not necesssary and the en d of the tag but is nicer to have to
make the code more readible.

set MyTag = IE.document.getelementsbytagname("iframe")

this will get all theiframeitems. You may have to look through each one
to find the correct one.

for each itm in Mytag
if itm.ClassName = "xyz" then

end if

next itm

Get address from iFrame reference in page source
 

Nope, it doesn't see the string. There is only one iframe on the page,
so that makes it 'simpler'.

Does the "SRC" have any implication in this for the '<iframe src=...'?
I'm guessing it is a shorthand for source.

Would it help to send you the page source? Thank you for your help,
this is beyond me at the moment.



S

On Sep 15, 12:09*pm, Joel wrote:
The address is probably in the string : MyTag.innertext.

set MyTag = IE.document.getelementsbytagname("iframe")

There are a few things to try

1) Put a break point on the line below the set Mytag by clicking on the line
and then pressing F9. *Run the code until the break point. *Then add watch
variable by highlighting with the mouse Mytag and right click mouse. *select
Add watrch and then press OK on pop-up window. then open the Watch variable
by clicking on the (+) plus sign. *My tag will be multiple items so you may
have to open each of the items in the watch window. *See if you find the
address

2) try this testt code
* *set MyTag = IE.document.getelementsbytagname("iframe")
* *for each itm in MyTag
* * * if instr(itm.innertext,"enter the address here") 0 then
* * * * * msgbox("Found Address")
* * * next itm
* *next itm

" wrote:
Hi Joel:

Method 2 finds the IFRAME tag, but I still can't figure out how to
grab the address. *I've been digging through documentation online, but
I don't know how to phrase my question correctly for this. The site I
am navigating through is a database for our online donations.
Currently I log in, run a report and request the report in Excel
format. The fields and buttons I manipulate in order to export the
data to Excel format are all contained in an iFrame and I can't access
any of the objects.

I am trying to open the iFrame address using code and the only place I
can find it is in the page source. ViewSource

That's the string I provided at the beginning.

Once I've got that string, I want to extract the sessionID and GUID
which I can use in another string to force the export to an Excel
file.

Does that help?

Steven

2) Or do you already have an Internet object and are try to find the tag
item "iframe". *Tags start with <iframeand end with * */iframe *or / . The
tag name is not necesssary and the en d of the tag but is nicer to have to
make the code more readible.

set MyTag = IE.document.getelementsbytagname("iframe")

this will get all theiframeitems. *You may have to look through each one
to find the correct one.

for each itm in Mytag
* *if itm.ClassName = "xyz" then

* *end if

next itm

Get address from iFrame reference in page source
 

It is probably Mytag.src

that is why I suggested to put a break point on the next line and add a
watch. You should be able to verify if it is sSCR. SRC may also be under
ALL, Children, or Item

" wrote:

Nope, it doesn't see the string. There is only one iframe on the page,
so that makes it 'simpler'.

Does the "SRC" have any implication in this for the '<iframe src=...'?
I'm guessing it is a shorthand for source.

Would it help to send you the page source? Thank you for your help,
this is beyond me at the moment.



S

On Sep 15, 12:09 pm, Joel wrote:
The address is probably in the string : MyTag.innertext.

set MyTag = IE.document.getelementsbytagname("iframe")

There are a few things to try

1) Put a break point on the line below the set Mytag by clicking on the line
and then pressing F9. Run the code until the break point. Then add watch
variable by highlighting with the mouse Mytag and right click mouse. select
Add watrch and then press OK on pop-up window. then open the Watch variable
by clicking on the (+) plus sign. My tag will be multiple items so you may
have to open each of the items in the watch window. See if you find the
address

2) try this testt code
set MyTag = IE.document.getelementsbytagname("iframe")
for each itm in MyTag
if instr(itm.innertext,"enter the address here") 0 then
msgbox("Found Address")
next itm
next itm

" wrote:
Hi Joel:

Method 2 finds the IFRAME tag, but I still can't figure out how to
grab the address. I've been digging through documentation online, but
I don't know how to phrase my question correctly for this. The site I
am navigating through is a database for our online donations.
Currently I log in, run a report and request the report in Excel
format. The fields and buttons I manipulate in order to export the
data to Excel format are all contained in an iFrame and I can't access
any of the objects.

I am trying to open the iFrame address using code and the only place I
can find it is in the page source. ViewSource

That's the string I provided at the beginning.

Once I've got that string, I want to extract the sessionID and GUID
which I can use in another string to force the export to an Excel
file.

Does that help?

Steven

2) Or do you already have an Internet object and are try to find the tag
item "iframe". Tags start with <iframeand end with /iframe or / . The
tag name is not necesssary and the en d of the tag but is nicer to have to
make the code more readible.

set MyTag = IE.document.getelementsbytagname("iframe")

this will get all theiframeitems. You may have to look through each one
to find the correct one.

for each itm in Mytag
if itm.ClassName = "xyz" then

end if

next itm

Get address from iFrame reference in page source
 

On Sep 15, 12:56*pm, Joel wrote:
It is probably Mytag.src

that is why I suggested to put a break point on the next line and add a
watch. *You should be able to verify if it is sSCR. *SRC may also be under
ALL, Children, or Item

Hi Joel:

Wow, I've never used a watch before just breakpoints. That's very
cool. So, it is MyTagItem 1SRC

I've got the address now in a string. I'm going to use the code you
provided earlier to separate out the sessionID and GUID.

Thank you! You've been a great help. I'm sorry for all the frustration
I must have caused.



Steven

Get address from iFrame reference in page source
 

I often set up dummy variables to use for the watch

set a = thisworkbook
set b = activecell
set c = Range("A1")


The add a, b, c to the watch.

" wrote:

On Sep 15, 12:56 pm, Joel wrote:
It is probably Mytag.src

that is why I suggested to put a break point on the next line and add a
watch. You should be able to verify if it is sSCR. SRC may also be under
ALL, Children, or Item

Hi Joel:

Wow, I've never used a watch before just breakpoints. That's very
cool. So, it is MyTagItem 1SRC

I've got the address now in a string. I'm going to use the code you
provided earlier to separate out the sessionID and GUID.

Thank you! You've been a great help. I'm sorry for all the frustration
I must have caused.



Steven

Get address from iFrame reference in page source
 

On Sep 15, 1:38*pm, Joel wrote:
I often set up dummy variables to use for the watch

set a = thisworkbook
set b = activecell
set c = Range("A1")

The add a, b, c to the watch.

" wrote:
On Sep 15, 12:56 pm, Joel wrote:
It is probably Mytag.src

that is why I suggested to put a break point on the next line and add a
watch. *You should be able to verify if it is sSCR. *SRC may also be under
ALL, Children, or Item

Hi Joel:

Wow, I've never used a watch before just breakpoints. That's very
cool. So, it is MyTagItem 1SRC

I've got the address now in a string. I'm going to use the code you
provided earlier to separate out the sessionID and GUID.

Thank you! You've been a great help. I'm sorry for all the frustration
I must have caused.

Steven

Good suggestions, I'll start incorporating that into my building. Far
more effective than the method I have been currently using - hovering
the mouse over variables to see values or MsgBox to pop up names.

Thank you again!

Steven