By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

Internet Instances

P: n/a
Hi

I have a list of favorite websites in a table.

I use the following command to view it:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!web_address
Call Shell(strAppName, 1)

Problem is iexplorer keeps opening a new instance each time it's called.

Is there a way to track the old instance and open another page in place of
the old one?
Thanks in advance
Jan 10 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Just use FollowHyperlink, with the URL.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@optusnet.com.auwrote in message
news:47***********************@news.optusnet.com.a u...
>
I have a list of favorite websites in a table.

I use the following command to view it:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!web_address
Call Shell(strAppName, 1)

Problem is iexplorer keeps opening a new instance each time it's called.

Is there a way to track the old instance and open another page in place of
the old one?
Jan 10 '08 #2

P: n/a
Thanks for replying
Sorry I'm not sure if I was clear enough.
In this example I would have 2 instances of Internet Explorer appear:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!txtWebAddress1
Call Shell(strAppName, 1)
strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!txtWebAddress2
Call Shell(strAppName, 1)

What I want is for the second shell call to find the first instance, and
replace the URL so that the new address would appear instead of the first.

Is this possible?

By the way, your website is fantastic.
"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:47***********************@per-qv1-newsreader-01.iinet.net.au...
Just use FollowHyperlink, with the URL.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@optusnet.com.auwrote in message
news:47***********************@news.optusnet.com.a u...
>>
I have a list of favorite websites in a table.

I use the following command to view it:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!web_address
Call Shell(strAppName, 1)

Problem is iexplorer keeps opening a new instance each time it's called.

Is there a way to track the old instance and open another page in place
of the old one?

Jan 10 '08 #3

P: n/a
"Dominic Vella" <do***********@optusnet.com.auwrote in message
news:47**********************@news.optusnet.com.au ...
Thanks for replying
Sorry I'm not sure if I was clear enough.
In this example I would have 2 instances of Internet Explorer appear:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!txtWebAddress1
Call Shell(strAppName, 1)
strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!txtWebAddress2
Call Shell(strAppName, 1)

What I want is for the second shell call to find the first instance, and
replace the URL so that the new address would appear instead of the first.

Is this possible?

By the way, your website is fantastic.
"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:47***********************@per-qv1-newsreader-01.iinet.net.au...
>Just use FollowHyperlink, with the URL.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@optusnet.com.auwrote in message
news:47***********************@news.optusnet.com. au...
>>>
I have a list of favorite websites in a table.

I use the following command to view it:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!web_address
Call Shell(strAppName, 1)

Problem is iexplorer keeps opening a new instance each time it's called.

Is there a way to track the old instance and open another page in place
of the old one?
Forget about using Shell. Open IE via the API:

Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate2 me!txtWebAddress1

Then when you want to 'replace the url' :

ie.Navigate2 me!txtWebAddress2

Don't forget to:

Set ie = Nothing

when you're done with it.

Jan 10 '08 #4

P: n/a
Thanks, that's great.

Dom

"Stuart McCall" <sm*****@myunrealbox.comwrote in message
news:fm*******************@news.demon.co.uk...
"Dominic Vella" <do***********@optusnet.com.auwrote in message
news:47**********************@news.optusnet.com.au ...
>Thanks for replying
Sorry I'm not sure if I was clear enough.
In this example I would have 2 instances of Internet Explorer appear:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!txtWebAddress1
Call Shell(strAppName, 1)
strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!txtWebAddress2
Call Shell(strAppName, 1)

What I want is for the second shell call to find the first instance, and
replace the URL so that the new address would appear instead of the
first.

Is this possible?

By the way, your website is fantastic.
"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:47***********************@per-qv1-newsreader-01.iinet.net.au...
>>Just use FollowHyperlink, with the URL.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@optusnet.com.auwrote in message
news:47***********************@news.optusnet.com .au...

I have a list of favorite websites in a table.

I use the following command to view it:

strAppName = "C:\Program Files\Internet Explorer\iexplore.exe " &
me!web_address
Call Shell(strAppName, 1)

Problem is iexplorer keeps opening a new instance each time it's
called.

Is there a way to track the old instance and open another page in place
of the old one?

Forget about using Shell. Open IE via the API:

Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate2 me!txtWebAddress1

Then when you want to 'replace the url' :

ie.Navigate2 me!txtWebAddress2

Don't forget to:

Set ie = Nothing

when you're done with it.

Jan 14 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.