Hi,
On Excel, I'm the greenest of the green!!! But I do want to get better. I have an URGENT real estate project where I need to link an Excel file to a specific positon
on a webpage. Can someone PLEASE help this lost soul figure out how to do this!!!
Hi SavannahGal and welcome to the forum
Try this...
1st, go to the web site you want, and copy the URL
then in the cell where you want the info, go to Data/External Data/from web
copy the URL (as if you were going to that site)
You be directed to the web site and you will see a bunch of yellow and black arrows. Use these to select which part you want
select Import, and it will take you back to your sheet
Play around with arrows until you get the piece that you want, by right-clicking on the cell and selecting Edit Query.
Hope that helps
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks FDibbins for replying.
A question. ok I copied the URL.
Did you mean instead of the second copy URL, mean to say paste?
Hi, I figured it out. Thanks for your help. Have a nice weekend.
Sorry, yes I meant paste.
Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
It helped me get onto the right track. Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks