| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy / Paste from web page
I'm having problems with the formatting of a web query inside of a macro.
Maybe this is best posted in the programming group, so I apologize if that is the case. When I go to a web page -- http://finance.yahoo.com/q/is?s=HD&annual -- and select all (CTRL-A) and then 'Paste Special' as text into A1 I get everything in column A, which is what I want. When I create my external web query I choose to have no formatting but the results are still broken out in several columns. How can I write a macro to simply go to a website select all and copy that site and then paste special as text into my excel sheet? Is that possible? Have a good day, Ted |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing pivot table along with a copy and paste for each page fie | Excel Discussion (Misc queries) | |||
| How to create a macro which performs a copy-and-paste task every 5mins after data is refreshed from web page? | Excel Worksheet Functions | |||
| copy a page with hidden rows and only paste what is showing | Excel Discussion (Misc queries) | |||
| Reference an identical cell on a different page using copy/paste? | Excel Worksheet Functions | |||
| How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
Threaded Mode
