The Wise Owl logo (an owl and the company name)

Our training courses

Other training resources

Our training venues

Why we are different

Details for jpduffy3

jpduffy3 has participated in the following threads:

Added by jpduffy3 on 09 Jul 2020 at 01:50

Thank you for your very helpful tutorial entitled "Excel VBA Introduction Part 47.5 - Basic HTTP GET and POST Requests."  I have run into a problem that stumps me.  Following the tutorial, I get the following result:

***************************
<!doctype html>
<html lang="en">
<head>
  <base href="/">
  <meta charset="UTF-8">
    
    <meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
  <meta name="mobile-web-app-capable" content="yes">
  <title>Profits Run</title>
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Open+Sans:400,500,600,700,800">

  <link rel="apple-touch-icon" sizes="60x60" href="/assets/images/favicons/apple-touch-icon.png">
  <link rel="icon" type="image/png" sizes="32x32" href="/assets/images/favicons/favicon-32x32.png">
  <link rel="icon" type="image/png" sizes="16x16" href="/assets/images/favicons/favicon-16x16.png">
  <link rel="manifest" href="/assets/images/favicons/site.webmanifest">
  <link rel="mask-icon" href="/assets/images/favicons/safari-pinned-tab.svg" color="#5bbad5">
  <meta name="msapplication-TileColor" content="#da532c">
  <meta name="theme-color" content="#ffffff">
  
<link href="app.12d5769f220fe4fa467b.css" rel="stylesheet"></head>
<body>
  <div id="root"></div>
<script type="text/javascript" src="vendor-d7a24874.js"></script><script type="text/javascript" src="app-4c8acbc2.js"></script></body>
</html>
***************************
However, when I inspect the elements of the website, I get the information I am looking for.  I believe the problem is that the java script is not running, and I have been unable thus far to find out how to make the java script run so that I can scrape the portions of it that interest me.  

If you are able to give me a suggestion or a work around, I would be very grateful.  

Thank you

Added by jpduffy3 on 12 Dec 2017 at 16:30

This is a very interesting and helpful video.  Thank you for making this information available to us.  

I have one problem at the outset.  I downloaded your associated file, but, when I try to run the GetVideoPage macro, I get a runtime error.  The code is 8007005, "access denied."  The file is not altered in any way.  This error appears at the line that reads "XMLReq.send".  I have tried the same macro using a different workbook and a different URL with the same result. 

I am using Excel 2016 and running it on W10 Pro 64bit.  

What, if anything, am I doing wrong?  

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2025. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...