I am extracting table from a saved web page "BAJAJHLDNG.htm" following code contained in file "BOOK177.xlsm"
If I hard-code file name I get the output to "BAJAJHLDNGa.xlsx" properly by following code line.
.Open "GET", "C:\Users\firstname.lastname@example.org\Downloads\exp_2010\BAJAJHLDNG.htm", False
I prefer to get it from a sheet range so if Ichange it to
Filename = WbMaster.Sheets("Sheet2").Range("A" & j).Value
.Open "GET", "C:\Users\email@example.com\Downloads\exp_2010\" & Filename & ".htm", False
This gives me the following error on
I require help in modification of code so that program take a filename from Sheet range. I have Excel 2016 and VBA program is utilising Excel VBE. I have to automate it further as nealry 2000 web pages are to be processed over a duration of 40 days.