Home > Software engineering >  Want to use VBA scraping of the page data to EXCEL spreadsheet
Want to use VBA scraping of the page data to EXCEL spreadsheet

Time:09-23

Want to use VBA to grab a data page, to automatically write Excel form, web page need password, use wireshark caught all obtained the data, but it won't write a POST in VBA in, asking great god is!

CodePudding user response:

My idea is to use wireshark capture data, according to the same statements written in VBA of the GET and POST, you'll GET the same results, can be the first step to POST account password into don't go,

CodePudding user response:

The great god come ah urgent solution

CodePudding user response:

Use fiddler to see, if you little cookie, referer or ua is inconsistent

CodePudding user response:

Have cookies, but don't know need to write, how to write

CodePudding user response:

Advice to learn first HTTP acquisition in excelhome BBS

CodePudding user response:

Where is definitely wrong format
You add the COOIKE
Is the segment on ASP.NET _SESSION look you copy down hair.
Another might be to the SESSION, if you want to, may want to read the next SESSION
  •  Tags:  
  • VBA
  • Related