Then you forgot to require
request module. Add this at the top of your server.js
var request = require('request');
I did not mention this in tutorial because I thought its quite obvious. I'll add it now.
If you want to learn VBA then you can start here - http://chandoo.org/wp/excel-vba/ which has a series of tutorials for beginners. I write only general How-Tos and advanced use cases of VBA so stay tuned to my blog for more practical use cases - https://codingislove.com/tag/vba/
Hope that helps!
Application.ActiveWorkbook.Path = Path of the active excel workbook.
Replace it with full path of the your destination folder like - "C:\Users\Tom".
You got to figure out few things on your own.
Just keep writing code for different scenarios, you'll be able to optimize the code on your own soon. Good Luck :)
@shahin2137 There's nothing such as wait in HTTP request. You make a request and you get a response. HTTP client gives you only one response which is complete.
You'll get same response even if you add
application.wait for one hour. The missing data that you're looking for might be rendered on the client side. detailed explanation here - Best practices of scraping website data
@Mustapha-Aliyu Looks like you are not providing password in the connection string. According to docs, Login box is displayed only if password is not specified in connection string - https://msdn.microsoft.com/en-us/library/bb221162(v=office.12).aspx
Make sure that your connection string is correct.
That website uses sessions to avoid data scraping from simple HTTP requests. When request is first made from a browser it sets a session cookie and redirects to another URL in this format - http://www.whitepages.com/search/ReversePhone?utf8=✓&country_code=1&iso_code=us&full_phone=1-323-871-0142 which then redirects back to the original page with data based on session.
You have to either replicate the same in HTTP requests by reading cookies, setting cookies and handle redirection or use an actual browser.
Need a simple solution? Use Selenium.
You can define range of your cells with input data, loop through the range - get data from cell using
cell.value. Use it to call appropriate API or website, get back response, parse it and paste data into adjacent cells using
Just give it a try, its pretty simple.
Looks like your connection to Codingislove Forum was lost, please wait while we try to reconnect.