url

We received a excel sheet from a third party with macro's. It works fine when using Office2016 and Windows 10 build 1709 or older. But when using Windows 10 build 1803 it always goes to CONNECTION ERROR :S When we go to the original website it give back the response it should, but whenever...

Hello, I have this code: Dim xmlOBject As Object Set xmlOBject = CreateObject("MSXML2.DOMDocument.6.0") xmlOBject.async = False xmlOBject.Load ("https://www.boi.org.il/currency.xml")' just example URL and its load to the xmlOBject variable the XML resulte. Is there a way to convert a...

This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to by 'Get External Data' every year on January 1 at 00:01 local time? The following URL is currently in use on a worksheet within my workbook...

Hello, I'm trying to do a simple web query for a couple of sites, but however their tables are coded, it only queries the first page of the table rather than all results. When clicking to the next page of the table (or selecting to view all rows), the page URL doesn't change, which eliminates a...

<tbody> Hi I am having an issue performing a mass update on url addresses within excel. I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person. The root file...

I have over 40,000 url similar to this one below https://i.postimg.cc/4xRS70r0/Anne-Hathaway-10.jpg What I want to do is create a listing title automatically from the above link so it reads: ANNE HATHAWAY A4 GLOSSY PHOTO PRINT #10 *FREE P&P* So basically I am taking the name and number...

Hi, New to this forum as I cannot work out how to solve an issue that I have come across since we migrated our corporate email system from Lotus Notes to Office 365. Mr Excel has helped me a lot, by reviewing other peoples problems and proposed solutions, but I cannot find anthing on my...

hi, so i'd like to include a hyperlink in my file that will take you to a folder. the url is this "\shared folder\08-Aug\main folder" i have the date in cell A1 as "Aug 2019" is there a way i can make a formula that will factor in what the date in cell A1 says? Meaning it extracts the...

If one of the ret(1), ret(2), ret(3) is not found it skips it, but it pastes the next one in that row, rather than skipping; any ideas how to alter the code to achieve this please? Thanks. Option Explicit Sub Get_Prices() Dim Lastrow As Long Dim LastRow2 As Long Dim x...

Hello, Bit of a novice on pulling data from the web. The 3 lines in bold below work. But when I try to pull another element, ret(4), the code isn't working. How do I work out whether it is a class or attribute? Many thanks. Private Function getprices(ByVal URL As String) As Variant...

HI, I have an excel with 2 columns. Column A = Name Column B = 'URL' (www.google.com) Not all Column A's have URL field. some are blank. I want to create new tabs in the same excel and seperate out URL and NO URL data. Please advise.

I have a golf spreadsheet I've been using and want to try and take it to the next level. I want to be able to automatically update players handicaps from a website, specifically www.gam.org On that website you can lookup a players handicap by name or by course. However, once you're in this...

Hello, I have a list of URL links in excel and each link goes to a breif WAV file recording. In fact, when you click on the link the option pops up to either open or download. Is there a way to through VBA, MACRO, or other automated means to run through this list of over 40,000 and download...

Hello. I have a macro that is supposed to gather all the college football team schedules from ESPN.com into a spreadsheet. I've used this the past three years but now the macro is not working and I'm unsure why. I'm getting a "Run-time error '91': Object variable or With block variable not set"...

Hi I have here a VBA macro which checks a server status of an URL, placed in a cell (here C2). How could this macro be adjusted to test all urls in the given column? The code is: Private Changing As Boolean Private Sub RedirectChecker(ByVal url As String) Dim sh As Worksheet Set sh =...

H Guys - I have this code that deletes any images on the worksheet and then takes the url address in A2 and displays the image from the address 4 columns to the left. Public Sub Add_Images_To_Cells() ActiveSheet.Pictures.DELETE Dim lastRow As Long Dim URLs As Range, URL As Range...

Is there any way to include an image in a posting? I know that I can upload the image to a file-sharing website and enter its URL in the posting. I would prefer that the image appear within the posting when the webpage is rendered, without the reader having to click on the URL.

Hello. I have had the below formula in a spreadsheet for quite some time now. The purpose of this formula is to determine the name of the Excel file that holds the formula. A table called "t_Parameters" holds the name of a subdirectory that is appended to the end of the the directory. So, if...

Hi All, Im trying to connect a webpage using a code which i got from a website. When I tried with the default URL available in the code it worked perfectly. I changed the URL to the URL which i need to open and i get the following error "Automation error The object invoked has disconnected...

I have various lists of website URLs in all shapes and sizes and I want to just have each website to be in this format: www.[insert your domain name].com Examples: Column A www.normals.com (pretty straight and fwd. About 80% of my list is like this and I don't need to...