url cell reference

Hi everybody, I am extracting stock information from yahoo site in VBA code. I want the URL from which the information will be taken to be in accordance with cell C5. That is, the URL that is in cell C5 is the address from which the information will be taken to Excel. - Now it looks like this -...

Hi, I have a shape in Excel that when clicked on fires of the following code: Sub GetURL() Dim NewURL As String Dim FollowURL As String NewURL = ThisWorkbook.Sheets("Category Review").Range("AP107").Value ThisWorkbook.FollowHyperlink NewURL End Sub This code works fine...

Hi, I have posted a couple of requests on some forums with great suggestions, but nothing has quite worked. My scenario: I have a couple combo box dropdowns that will update a cell A1 (Range Name of URL) with a HYPERLINK formula (=HYPERLINK(XLOOKUP(A2,'Report Links'!$AJ:$AJ,'Report...

Hi Guys My first post here. Would love to get your help. I have a row full of urls and want to download a webquery into the adjacent row. Row A has the hyperlinks and I want to download as a text string all data for each hyperlink into Row B. Please let me know if this is possible and how...

Hey, Please help a NON coder, I need a VB code that does the following; Sheet 1 Cell C10 - Contains an image url (this can either be a file location or web address) I need to copy that url and use that to insert picture in cell J10 Once the image is in cell J10 the image width needs to be...

I have a workbook that has a column which contains the titles of different documents which are published to a website (B4:B6). Another column contains the URLs for those documents (C4:C6). <tbody> Document Title External Link How to Eat Worms www.fakewebsite.com/how-to-eat-worms How to Dig...

I have a dropdown that currently everything on a dashboard is changing against depending on which month is selected. I also have images that I want to show. The images are all hosted online. I have code from another thread...

I believe I have thoroughly researched this question (sorry if you have seen the answer, please be patient with me). Truly a newcomer to VBA/Macros and do not even fully understand where to "put" the codes that are provided in these message boards, that is why I prefer a formula. My sheet has...

Hi everybody, First of all, thank you all for your previous collaboration. I am currently engaging more with Excel [2010] and VBA, and with the stumbles along the way, your answers to other people's questions have been great answers to my questions as well. Usually with the Record Macro feature...

Hi All, I'm hoping someone can help. I have list of items, each of which has a barcode value. I want these barcodes to dsiplay in the last column. Unfortunately, add-in's aren't usable as the spreadsheet needs to be used by a number of users. I have previously used google sheets, where...

Hi there, Is there a way to post a specific cell value into a url with macro. here is the macro. I want to Paste the cell value of A1 into the end of the URL. I have also tried to put the desired url in A1 and just reference that. Range("A2").Select With...

My goal is to obtain data (specifically stock information from yahoo) by using different tickers **in cell B1**. FB Income Statement | Facebook, Inc. Stock - Yahoo! Finance Above is the URL for quarterly financials for ticker "fb". I would like to put the ticker in cell B1, run the macro, and...