Click here to Skip to main content
14,837,944 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionwkhtmltopdf.exe - Process-Start over COM-Interop - Access denied Pin
VoidFunctionMain10-Feb-21 4:48
MemberVoidFunctionMain10-Feb-21 4:48 
QuestionCode for Saving work Pin
Wamono erick5-Feb-21 7:52
MemberWamono erick5-Feb-21 7:52 
AnswerRe: Code for Saving work Pin
Dave Kreskowiak5-Feb-21 8:28
mveDave Kreskowiak5-Feb-21 8:28 
QuestionProblem when setting the ReadOnly state of a property: CLOSED Pin
mo149231-Jan-21 5:56
Membermo149231-Jan-21 5:56 
QuestionInterfacing with Zlib.dll Pin
albert_redditt28-Jan-21 10:16
Memberalbert_redditt28-Jan-21 10:16 
AnswerRe: Interfacing with Zlib.dll Pin
20212a28-Jan-21 10:30
Member20212a28-Jan-21 10:30 
AnswerRe: Interfacing with Zlib.dll Pin
Richard MacCutchan28-Jan-21 21:14
mveRichard MacCutchan28-Jan-21 21:14 
QuestionUnable to complete the code for Web scrapping Pin
The Mentee27-Jan-21 8:56
MemberThe Mentee27-Jan-21 8:56 
I am trying to making a webscraping code and i have searched a lot and could not find any relevevant code. which scrap the below details from the webside.

your help in this regard will be highly appreciated.

Item name
item price
Shipping price


Sub Web_Scraping()

  Dim Internet_Explorer As InternetExplorer
  Set Internet_Explorer = New InternetExplorer
  Internet_Explorer.Visible = True
  Internet_Explorer.navigate ("https://www.ebay.com/sch/i.html?_nkw=045496902612+-Disc+-Only+-Refurbished+-Used+-Lot+-Import+-Japan+-Repro+-Reproduction+-Replacement+-VGA+-Graded+-Edition+-Edtion+-EU+-Mod+-Mods+-Moded+-modded+-Digital+-Collection+-Bundle+-Code+-Codes&LH_TitleDesc=0&LH_BIN=1&LH_Sold=1&rt=nc&LH_PrefLoc=1&LH_ItemCondition=3")
Do While Internet_Explorer.readyState <> READYSTATE_COMPLETE: Loop
  MsgBox Internet_Explorer.LocationName & vbNewLine & vbNewLine & Internet_Explorer.LocationURL
  
  
  
  For Each item In respJSON("QuickQuoteResult")("QuickQuote")
    ThisWorkbook.Worksheets(1).Cells(i, "A") = item("Item name")
    ThisWorkbook.Worksheets(1).Cells(i, "B") = item("item price")
    ThisWorkbook.Worksheets(1).Cells(i, "C") = item("Shipping price")
  
End Sub

AnswerRe: Unable to complete the code for Web scrapping Pin
Richard Deeming27-Jan-21 21:49
mveRichard Deeming27-Jan-21 21:49 
GeneralRe: Unable to complete the code for Web scrapping Pin
The Mentee28-Jan-21 0:06
MemberThe Mentee28-Jan-21 0:06 
GeneralRe: Unable to complete the code for Web scrapping Pin
DerekT-P28-Jan-21 7:07
professionalDerekT-P28-Jan-21 7:07 
GeneralPersonal Appointment Reminder Code Pin
mike Pant10-Jan-21 2:58
Membermike Pant10-Jan-21 2:58 
GeneralRe: Personal Appointment Reminder Code Pin
Victor Nijegorodov10-Jan-21 3:59
MemberVictor Nijegorodov10-Jan-21 3:59 
GeneralRe: Personal Appointment Reminder Code Pin
Gerry Schmitz10-Jan-21 4:47
mveGerry Schmitz10-Jan-21 4:47 
QuestionExcel VBA Macro Pin
tutymano5-Jan-21 17:49
Membertutymano5-Jan-21 17:49 
AnswerRe: Excel VBA Macro Pin
Dave Kreskowiak5-Jan-21 19:55
mveDave Kreskowiak5-Jan-21 19:55 
AnswerRe: Excel VBA Macro Pin
Mycroft Holmes6-Jan-21 11:02
professionalMycroft Holmes6-Jan-21 11:02 
QuestionChange mac address by vba Pin
Member 1447788423-Dec-20 14:47
MemberMember 1447788423-Dec-20 14:47 
AnswerRe: Change mac address by vba Pin
Dave Kreskowiak23-Dec-20 17:30
mveDave Kreskowiak23-Dec-20 17:30 
GeneralRe: Change mac address by vba Pin
Member 1447788423-Dec-20 18:35
MemberMember 1447788423-Dec-20 18:35 
GeneralRe: Change mac address by vba Pin
Gerry Schmitz24-Dec-20 5:14
mveGerry Schmitz24-Dec-20 5:14 
GeneralRe: Change mac address by vba Pin
Dave Kreskowiak24-Dec-20 5:21
mveDave Kreskowiak24-Dec-20 5:21 
AnswerRe: Change mac address by vba Pin
Richard MacCutchan23-Dec-20 21:54
mveRichard MacCutchan23-Dec-20 21:54 
AnswerRe: Change mac address by vba Pin
Gerry Schmitz24-Dec-20 5:07
mveGerry Schmitz24-Dec-20 5:07 
QuestionIs there Access VBA method of translating text in a textbox? Pin
Member 1181158314-Dec-20 3:18
MemberMember 1181158314-Dec-20 3:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.