Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Data from a website to excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Data from a website to excel
When the data apears in the website, type CNTRL-A, CNTRL-C. Go back to the
workshet, click on a cell and type CNTRL-V. All the data should be transferred to the worksheet. You may need to do a little formatting to get the individual data items where you want them. -- Gary's Student "sanmisds1" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |