Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: wyt3dr4g0n
- Order by date
-
Copy table from website to Excel using Web Browser Object
OKAY! So I've discovered the awesomeness that is .ExecWB... seems to have done the trick and I can use it to perform either method. I decided to go with... oBrowser.ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DONTPROMPTUSER oBrowser.ExecWB OLECMDID_COPY, OLECMDEXECOPT_DONTPROMPTUSER Sheet2.Paste...- wyt3dr4g0n
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copy table from website to Excel using Web Browser Object
Ok so I've been developing a spreadsheet for use in collecting helpful information at the call center that I work at. It's been using webqueries and has worked great up to this point, however the primary intranet site I'm pulling data from has change it's login method to a more secure one and...- wyt3dr4g0n
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
