Advertisement
Guest User

Excel Post Crash

a guest
Jun 25th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub CrashExcel
  2.     Dim Query as Object
  3.     Set Query = ActiveSheet.QueryTables.Add(Connection:="URL;https://www.w3schools.com/html/html_tables.asp", Destination:=ActiveCell)
  4.     Query.PostText = "param=[""param"",""Enter param""]"
  5.     Query.Refresh
  6. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement