Prev: Userform combobox matchrequired = True; error with no selectio
Next: Visual Basic Editor opens automatically after lock, unlock
From: rcb on 15 Jan 2010 15:25 From an Excel Macro, I need to pass a URL to IExplorer, log in to a site, and then perform some commands to export data an Excel file. This application will run on a scheduled basis (weekly, perhaps) to append the data to Excel and process it. Any ideas? -- CrawfordB
From: joel on 15 Jan 2010 20:51
It is a piece of cake to pass a URL to a webpage from VBA, it is not that easy to get the data without seeing the webpage. Every webpage is different anwithout know the exact data you need you need some help. Yo can find lots of example if you do a google search for VBA EXCEL IE If you add JOEL to the search you find plenty of examples that I have people with. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=170573 [url="http://www.thecodecage.com"]Microsoft Office Help[/url] |