ip address

I'm trying to use VBA to scrape all IP addresses from all Excel files in a given user-selected folder. I have gotten this to work with the IPV4 addresses, but the couple IPV6 regex variations I've tried do not work. Does anyone have a tested IPV6 regex I can insert here? 'Create regular...

I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...

Similar to this old thread https://www.mrexcel.com/board/threads/vlookup-to-return-yes-and-no-values.407539/#post-2020521 But, I have a string in column A like below, outputs in D & E and two IPs in B&C. Appreciate for a VB Script if possible, or is there another way aside from vlookup...

Hi, I need to populate almost 10 columns with information from another excel sheet. We usually do it using vlookup. Can we use a macro and automate it. SO that I just click once and all the columns gets populates. Table A where the information needs to be populated <tbody> IP Location Metal...

Hi a Colleague wrote the below and has now left the company, I now need to expand the code so in cell.offset (0, 4) it will display the FQDN, is this possible? The IPs start at Cell 'A2' and generally go down to row 254 Thanks in advance Stuart :confused: Sub PingTest() Dim Cell As...

I have the ff. tables in a worksheet: Table A (Sheet 1) - a list of 1000+ computers that don't have a specific piece of software installed Table B (Sheet 2) - a list of 15000+ host-to-IP address entries from the local DNS obtained using the <code style="margin: 0px; padding: 1px 5px; border...

I have a list of IP addresses: 10.9.8.14 10.9.8.24 10.9.8.17 10.9.8.56 10.115.4.3 10.115.4.16 10.115.4.88 10.24.2.132 10.24.2.55 I am looking for a formula to take this column and generate the following in the next column: 10.9.8.0 10.9.8.0 10.9.8.0 10.9.8.0 10.115.4.0 10.115.4.0 10.115.4.0...

I am trying to find a formula for column A that will check an IP address in column B and find if if falls into a range (or between) 2 addresses in in two other columns. C and D. E.G. <tbody> Valid? address range start end yes 10.1.1.5 10.1.1.0 10.1.1.31 yes 10.1.3.13 10.1.2.16 10.1.2.31...

Hi, I'd like to know if there's a simple code for getting the vpn and ip address of a computer. Thanks. I already have the code for the username - I'm missing getting vpn and ip address or where the computer connects to the internet.

Hi guys - I have am trying to take a list of 250k IP Addresses and determine if they are in subnets that are part of my organization. I would prefer to do this with just formulas but am open to VBA as well...i just dont understand it as well. The first two columns I have, the third is my...

I've got a spreadsheet consisting of several ODBC queries that I need to distribute to multiple individuals. The ODBC server's IP address in the Connection String will be different for each individual so I'm looking for a way to update the server's IP address based off of an IP address I enter...

Hello first time poster here, I'll try to be as clear as I can :) I am currently being slowly driven to the brink of madness trying to work out why a vlookup is always returning #NA. The goal is for every IP address listed in a table I need to automatically work out the location based on the...

Im sure this has been posted but after reading over this forum and others i still cannot find a solution. Given the first two columns of IP addresses i want to generate the third or even fourth Column <tbody> StartIP EndIP Total IPs Total /24s 1.32.0.0 1.32.127.255 32,766 128 2.15.0.0...

Hi I'm struggling to extract the last 1,2 or 3 digits from an IP address. the problem I have is that I have different length of IP address, so for example 10.1.93.145 145.10.5.16 145.168.192.1 I am trying to extract the numbers after the last full stop so the above example results would be...

Guidance please .. I have two worksheets in my excel file. Sheet 1 - a list of IP addresses in column E ex: '1.123.57.208' Sheet 2 - a list of IP address ranges (roughly 11k rows) assigned to a particular country in columns A, B & C respectfully ex: '16.777.216' | '17.367.039' | 'AUSTRALIA'...

I need to connect to windows program another computer. The program has a winsock protocol running. I can telnet from the terminal of my mac and send and receive data. I would like to be able to do this inside excel with vba. I can imagine a separate program (ruby or something) that will do...

Hello and thank you for your time. I am attempting to categorize IP Addresses. My lookup table looks like this: Begin End Category 1.50.50.0 1.50.50.255 3 5.185.40.0 5.185.43.0 2 5.22.22.65 5.22.22.128...

Does anyone know how I can format a cell to always add zeros to IP addresses? ex. change 69.21.13.222 to 069.021.013.222 The cells data is being populated from other spreadsheets using a VLOOKUP. I just need the leading zeros. Thanks

I have some code that will parse the FIRST IP address it finds in a string. Could someone help with the code for continuing through the remaining part of the string and parsing out any additional IP addresses it finds and concatenating them with a comma and space (", ")? There are specific...