Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello, Everyday I log into a clients website, which is password protected, and export the data (shipping and tracking information) for different orders into Excel followed by I do what I do. Problem is I hate doing it and I know there is a way using Data-Import External Data - New Web Query and enter the web add...and blah.... Well, this is not working for me. It gives me just the headers. I have tried with other web sites to try and it works just fine. Is there a way using VBA or Macro to extract all the Data from the table and export to Excel? FYI_ When I am in the website, I need to click Filter button to pull the data...data itself do not launch. It sounds messed up but it is very viable...just not through me. Can you please help me? I appreciate it. Thanks! -- sanmisds1 ------------------------------------------------------------------------ sanmisds1's Profile: http://www.excelforum.com/member.php...o&userid=25241 View this thread: http://www.excelforum.com/showthread...hreadid=391466 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import data from a website to excel | Excel Worksheet Functions | |||
Importing Data From a "Formula-Based Website" | Excel Discussion (Misc queries) | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
Importing text from a website | New Users to Excel | |||
importing info from a website using a macro function | Excel Programming |