Capture network traffic in IE to file

Status
Not open for further replies.
A

Andrzej

Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
Dear Colleagues,

I need to do the following by VBA procedure in Outlook:

1) open in Internet Explorer http:// www. anyaddress.com
2) wait (about 15 seconds) until IE redirects to https:// www. hugedomains.com/domain_profile.cfm?d=anyaddress&e=com
3) read the word "hugedomains" from URL2

I am using WinHttpRequest object to realize that task, but I cannot find property which returns redirected URL
(see attached Sub url_redirect)
I got stuck. Can anybody give me a clue?

I am wondering about another solution : write a code which captures network traffic (IE F12, Network, save to file option), saves to file (networkdata.xml) and finds "hugedomains" word by function InStr, but in this case I completely don't know how to do that....

Sorry for asking maybe stupid (hope not) questions, but I really don't know how to go further.

Regards,
Andrzej Nizankowicz

(admin: hoping my edit to show the urls makes it easier to understand)
 

Attachments

Last edited by a moderator:
The big problem (as i see it) is controlling IE (or any browser) using VBA - your options are fairly limited. Fiddler could get the url but i don't know about reading it using VBA. You may need to forget outlook and use C## or a VB program in Windows.

Do you just need to get the keyword and is it anywhere in the webpage after redirect? Reading the page might be doable.
 
Do you have a url that takes longer to redirect? I think it's working as you want here - but my redirects are fast.
when i use
adr = "http:// slipstick.me/17wlo"

the msgbox has the redirected url - it's the same with your url. i can then use regex or instr to find the redirected url.
HTML: 
---------------------------
Microsoft Outlook
---------------------------
<!DOCTYPE html>
<html lang="en-US" prefix="og: http://ogp.me/ns# fb: http://ogp.me/ns/fb#">
<head>
<meta charset="UTF-8"/>
<title>Block Macros in Office 2013/2016</title><meta name="viewport" content="width=device-width, initial-scale=1"/>
<meta name="description" content="The August 9 2016 security update for Office 2013 included a non-security feature to allow administrators to use Group Policy to block macros from running in files that are downloaded from the Internet. This feature was added to Office 2016 earlier this year."/>
<meta name="robots" content="noodp"/>
<link rel="canonical" href="http://www.slipstick.com/outlook/block-macros-office-20132016/"/>
<meta property="og:locale" content="en_US"/>
<meta property="og:type" content="article"/>
<meta property="og:title" content="Block Macros in Office 2013/2016"/>
<meta property="og:description" content="The August 9 2016 security update for Office 2013 included a non-security feature to allow administrators to use Group Policy to block macros from runn
---------------------------
OK  
---------------------------



Your adr url returns me this and i can get the path from the title or css path.

HTML: 
---------------------------
Microsoft Outlook
---------------------------

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>HugeDomains.com - AnyAddress.com is for sale (Any Address)</title>
<link rel="stylesheet" href="https://static.HugeDomains.com/css/common.css" />
<link rel="stylesheet" href="https://static.HugeDomains.com/css/v3.css" />
<link rel="stylesheet" href="https://static.HugeDomains.com/css/pages_v3b.css" />
<link rel="stylesheet" href="https://static.HugeDomains.com/css/styles_hd.css" />
<script type="text/javascript" src="https://static.HugeDomains.com/js/common.js"></script>
<script type="text/javascript" src="https://static.HugeDomains.com/js/common_v3.js">
</script>
<script type="text/javascript" src="https://static.HugeDomains.com/js/jquery-1.5.1.min.js"></script>
<script language="javascript"> function headerWindowLoad() { return true; } </script>
<script
---------------------------
OK  
---------------------------

(hoping this will be readable)
 
Dear Diane,
Thank you very much for the answer, but...
URL1 and consequently URL2 was only an example. I am doing that on classified network and I can't give real example.
After redirection from URL1 to URL2 there is no url2 in the HTML page
(I've checked the whole redirected html, I mean section <head> and <body>).
While pressing F12 in IE I can see desired word: Bookmark "network"; in left column URL
(next: protocol HTTP/ Method GET/ Result 200 / Type application json / ...)
How to retrieve that data ? I would really appreciate any idea.

Regards,
Andrzej
 
Dear Diane, Dear Colleagues,
I need somehow to read redirected URL2
I'm almost decided to capture network traffic and save it to file.
Can anyone tell me if it's possible with VBA and how to do that?
I really appreciate any clues...

Regards,
Andrzej
 
Status
Not open for further replies.
< Linking Excel Cell to Shared Contacts | Apply customized Business Card for all users >
Similar threads
Thread starter Title Forum Replies Date
L Capture email addresses and create a comma separated list Outlook VBA and Custom Forms 5
R Capture Sender's Display name and Address Outlook VBA and Custom Forms 3
M Using field names to capture a data element Using Outlook 0
I Capture incoming emails Outlook VBA and Custom Forms 1
JorgeDario How to capture and save the text, when responding a MailItem? Outlook VBA and Custom Forms 3
G Capture "forward event" ? Outlook VBA and Custom Forms 11
J VBA Form in Outlook to capture data and complile a mail Outlook VBA and Custom Forms 2
A how to capture events for next item Outlook VBA and Custom Forms 10
B Capture Inbound E-mail Subject with VBA Outlook VBA and Custom Forms 4
R How to capture a Mailitem Event Outlook VBA and Custom Forms 3
A how to capture outlook 2007 events Outlook VBA and Custom Forms 4
T Some way to capture who marks an email as read Outlook VBA and Custom Forms 1
C Event Capture - Item Context Menu (Delete). Can you hook it? Outlook VBA and Custom Forms 1
R Adding Userform Dropdown List items from names of subfolders on network drive Outlook VBA and Custom Forms 10
R Advise on using multiple instances of network files based on customers Outlook VBA and Custom Forms 8
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N Save emails within a certain date range to network drive Outlook VBA and Custom Forms 0
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
S automate save the .xlxs file to share Network Using Outlook 1
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
G How to have domain client use owa server instead of exchange server while connect to network Using Outlook 1
B Macro to manually move selected emails to network folder Outlook VBA and Custom Forms 1
R Make Enter Network Password Prompt Go Away Automatically Using Outlook 0
Diane Poremsky Enter Network Password Dialog Keeps Popping Up Using Outlook 0
Jessica .msg file saved in network drive appearing in Deleted Items folder Using Outlook 3
J Automatically Move Old Items from a Shared Mailbox to a .PST on a Network Drive Outlook VBA and Custom Forms 1
nathandavies How to save emails to a specific folder on a network automatically using a macro Outlook VBA and Custom Forms 14
S VBA to identify a specific email and copy the attachment from it to the network Outlook VBA and Custom Forms 4
D Automatically save attachment to network folder Exchange Server Administration 1
G Enter Network Password box pops up every few seconds Using Outlook 2
J Joint mail folders over network and archiving Using Outlook 1
B Outlook network password problem. Using Outlook 0
E Outlook 2010 network printing problems Using Outlook 4
E Can't print from Outlook on wifi network Using Outlook 0
W New Problem using Outlook over network Using Outlook 1
Commodore Outlook 2007 not closing network connections with RSS feeds Using Outlook 1
R Limiting Outlook Access to Inside Network Only Exchange Server Administration 1
A Problems with moving msg files to network folder Using Outlook 3
R Rules and Alerts not sending emails to "outside Network" emails Using Outlook 1
E prompting for "Enter Network Password" Using Outlook 2
J Outlook 2007: "Enter Network Password" Pop-ups Using Outlook 22
V Saving Multiple Network Passwords Using Outlook 0
A Network Permissions for sharing calenders between exchange severs Using Outlook 1
M Outlook 2007 - Save outgoing attachments to network drive on sending? Using Outlook 1
R Create a network PST file with office customization tool office 2010 Using Outlook 4
Y MICROSOFT OUTLOOK 2007 - i KEEP GETTING THE "ENTER NETWORK PASSWORD" BOX POPPING UP - IT IS ALREADY Using Outlook 4
L Sending reported error - 0x800CCC13. Cannnot connect to the network Using Outlook 5
S Enter Network Password Box keeps popping up in Outlook 2007 Using Outlook 3
T email Access report pop up network error Outlook VBA and Custom Forms 1
D Sharing BCM Database with other computers on a network BCM (Business Contact Manager) 1

Similar threads

Back
Top