| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I download data into MS Excel from a Website that takes a l
There is a stock broker's Website that I can access with a login/password.
How can I download data from that account into an Excel spreadsheet? My OS is WIN XP. I have tried both a WebQuery and a Macro that I wrote but have been unsuccessful. The program chokes up at the login stage. Your help will be deeply appreciated. -- XL Baby |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I download data into MS Excel from a Website that takes a l
Maybe Copy PasteSpecial Text, and then Data Text to columns to split it
into separate columns......... Vaya con Dios, Chuck, CABGx3 "XL Baby" wrote: There is a stock broker's Website that I can access with a login/password. How can I download data from that account into an Excel spreadsheet? My OS is WIN XP. I have tried both a WebQuery and a Macro that I wrote but have been unsuccessful. The program chokes up at the login stage. Your help will be deeply appreciated. -- XL Baby |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I download data into MS Excel from a Website that takes
Chuck,
Would you use that as part of a Web Query or a Macro? Tks. -- XL Baby "CLR" wrote: Maybe Copy PasteSpecial Text, and then Data Text to columns to split it into separate columns......... Vaya con Dios, Chuck, CABGx3 "XL Baby" wrote: There is a stock broker's Website that I can access with a login/password. How can I download data from that account into an Excel spreadsheet? My OS is WIN XP. I have tried both a WebQuery and a Macro that I wrote but have been unsuccessful. The program chokes up at the login stage. Your help will be deeply appreciated. -- XL Baby |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I download data into MS Excel from a Website that takes
Maybe try turning on the Macro Recorder and then go through all the normal
steps you would do by hand to import the data.....then turn off the recorder and see what you have.......perhaps something good enough to edit to make it right. Vaya con Dios, Chuck, CABGx3 "XL Baby" wrote: Chuck, Would you use that as part of a Web Query or a Macro? Tks. -- XL Baby "CLR" wrote: Maybe Copy PasteSpecial Text, and then Data Text to columns to split it into separate columns......... Vaya con Dios, Chuck, CABGx3 "XL Baby" wrote: There is a stock broker's Website that I can access with a login/password. How can I download data from that account into an Excel spreadsheet? My OS is WIN XP. I have tried both a WebQuery and a Macro that I wrote but have been unsuccessful. The program chokes up at the login stage. Your help will be deeply appreciated. -- XL Baby |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Web Query for Java Applet driven data website | Excel Discussion (Misc queries) | |||
| Download excel doc from website, can this be done? | Excel Worksheet Functions | |||
| want to download csv file from website and need to open in Excel. | Excel Discussion (Misc queries) | |||
| How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
| How do I import data from a SECURED website into Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
