halobender
Technical User
- Mar 16, 2007
- 37
Hey all I have an issue and could use some extra brains.
Here is what I have..
I have a web query created in excel 2010 which has imported three columns and 500 rows
A = web hyperlink text
B = place
C = place
I need to find a way to use vba or the web query itself to visit the web hyperlink copy all text and paste back to column D
I am at a loss and have no code to even offer as everything I've tried has resulted in ultimate failure.
Here is what I have..
I have a web query created in excel 2010 which has imported three columns and 500 rows
A = web hyperlink text
B = place
C = place
I need to find a way to use vba or the web query itself to visit the web hyperlink copy all text and paste back to column D
I am at a loss and have no code to even offer as everything I've tried has resulted in ultimate failure.