url

Hi, Can anyone please help? I have the following code and I am looking to Google Maps to return the url of the final page. At present it is only returning the intitial load up url. Below is my simple code so far, Sub GotoAddress() Dim IE As New InternetExplorer IE.Visible = True...

Hi, I have data from a data base that I export into excel and paste into an excel spreadsheet which formats the data to look presentable. The data has a google maps location URL column and I would like to write some VBA based on the cells with the URL to insert a satellite image of this...

Please can someone help, I have this code which pretty much does what i want, only problem is that it stops at row 414 every time for some reason. I have attached a downloadable excel sheet, see link below. i have removed all the emails from it. on sheet 1 there are about 3000+ url and one...

Hi. Hope some one can help, I have been stuck on this for a few days and cant seem to work it out. I have a large list of customers and email address which i need to match from one sheet to another. On sheet 1 Column A, I have URLS and in column B I have email addresses to those URLs. Not all...

Hi, I have a query (get data from web > Table_2) Will a URL like: http://examplesite.com/go.php?account=1331&date=2019010301 Now I'm wanting to control account + date from cell values though unsure how. I've recorded a macro and modified the URL but it is still fetching the same original...

Please note: This post is a cross-post. I posted this question on Feb. 23rd on Stack Overflow and have not gotten any responses. I am posting here in hopes that someone may have not seen that post and may be able to help me here. Here's the link to the cross-post on Stack Overflow: link. I...

Hi All, I need an output that displays the URL in column A (Old URL) that most closely matches the URL from column B (New Url) The product name & code number stay the same in both A & B there are just some extra categories in the column B list The output needs to be Something like Column A...

Hello, I have a VBA to save multiple URL’s as a text file. Column B is the 8 URL’s and column C is the 8 text file names to be saved. When I run the code, it creates 8 text files, but the eight text files are an exact replica of the last URL used. Example: If I run only two URL’s both files...

How can i use the below code to scrap tables from multiple URLs and paste them one below other on single sheet

I have thousands of rows which has string like <img src="https://www.rd-shop.de/out/pict/gene/product/1/450_/sposet_gr_14045.jpg" /><br> String length is not always same, url can vary etc. How I extrack string "sposet_gr_14045.jpg" from cell? It is picture file.

I've never used 365's PowerQuery before, but I'm told that it can handle exactly these kinds of requests. Here's a static Yahoo URL with all the stock option data for symbol AAPL: https://query1.finance.yahoo.com/v7/finance/options/AAPL But not sure where to go from here; following online...

Hi - Sorry if breaking protocol here, but I posted to an old post this morning which probably doesn't have any visibility at this point. I placed the URL below and would appreciate if someone could review and reply to the inquiry. Thanks in advance...

Good Afternoon, i am using this code to search anything listed in Column A which seems to work fine however if i write a number and not text it breaks can anyone hel. Sub XMLHTTP1() Dim url As String, i As Long, lastRow As Long Dim XMLHTTP As Object, html As New...

Hi, I have a web query that runs through Powerquery with a table And the URL ends in a date like: &Date=20190101 How can I control this date from a cell value? I know I need to use the advanced editor but unsure how, it's nothing like VBA. Appreciate any help

Hi There I'm stuck...Please help..:eeek: I'm a request fulfilment manager, and I have an Excel sheet which is an extract from our Helpdesk system. It's 70.000+ rows. Here is my challenge: In colum A I have a unique number for the specific Request i.e. RFxxxxx and in colum B I have an URL that...

Hello I need an if then or else statement that will check an https:// SharePoint url to see if a file exists. If it does, then a msgbox that will ask if you would like to overwrite. If not then exit Sub. The problem I'm experiencing here is: Url access to SharePoint does not require a...

I am new to VBA and have to complete a task for my manager about saving sheet as a pdf into sharepoint (if firstly can be done) which creates a folder at the location with the same name as the saved PDF and saves the pdf there.Now where it gets harder for me is at the location in sharepoint...

I am trying to extract the image from url and embed in excel 2007. My Excel is simple , it contains 2 columns , Column 1 has the image url and in other column i want the embed the image. i am using the attached code , it is working perfectly fine for first row where i have saved the image from...

Hi all, I have a list of SharePoint file URLs and I need you help with a formula to extract part of the URL up to the 2nd sub directory or sub-site e.g. http://company.sharepoint.com/teamsite/Subdirectory1/ http://company.sharepoint.com/teamsite/Subdirectory1/folderA/folder1/...

Hi Friends I have created a macro. If I run this macro I visit a URL which is mentioned in my vba code. I want to change this url every time. so is there a way that I enter the URL in excel cell A2 (Sheet1) and vba pick the url from this cell instead of mentioning the url in vba. Please help me...