Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2012, 02:15 AM
Wries Wries is offline Macro - Get External Data From Web Windows XP Macro - Get External Data From Web Office 2007
Advanced Beginner
Macro - Get External Data From Web
 
Join Date: Jun 2009
Posts: 40
Wries is on a distinguished road
Default Macro - Get External Data From Web

Hello All,


Can you please let me know if there is a command in macro that will open the get external data window?

To describe my problem, I have created the macro that import tables with stats from the website (monthly statistics where user select which months to import).
The problem is the website requires a login.

It works when i manually click on the get external data, log in, close web query window and then run the macro.

What i need is to implement the login into another macro, best would be a command that will open the Get external data and let user to manually log in.

Using the internet explorer application does not do the job as excel do not "remember" or recognize being logged in and therefore the macro cannot access the tables.

Many thanks,
Kind regards,
Wries
Reply With Quote
  #2  
Old 10-31-2012, 08:00 AM
Wries Wries is offline Macro - Get External Data From Web Windows XP Macro - Get External Data From Web Office 2007
Advanced Beginner
Macro - Get External Data From Web
 
Join Date: Jun 2009
Posts: 40
Wries is on a distinguished road
Default

Hello, let me answer my question in case someone else is looking for the same macro.
I havent been able to find a direct command, if anyone can solve it without using sendkeys please share your solution.

For the time being the following seems to work:

Sub GetExternalDataFromWeb()
SendKeys "%"
SendKeys "d"
SendKeys "d"
SendKeys "w"

End Sub

Kind regards,
Wries
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro - Get External Data From Web drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
Macro - Get External Data From Web vba change external data source excelledsoftware Excel Programming 1 07-17-2012 04:22 AM
Macro - Get External Data From Web Refresh of data from external source Jirik61 Excel Programming 3 07-13-2012 01:40 PM
Macro - Get External Data From Web Consolidating data using Macro mrjamez Excel Programming 2 05-22-2012 06:50 AM
Help w/ external data bellest Excel 0 11-11-2005 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft