Nov 24, 2016 - Public Function IPRange(IPandMaskInput$) ' PROGRAM: ' IP Range Calculator by Tomas Pospisek that. This is a VBA Function for Excel. Excel IP Address Lookup using Geoip Service. From this API we can get locations details of ip addresses either in JSON, CSV or XML formats. This API limits number of requests per hour to 10,000 queries. The below sample code can fetch the JSON format to your Excel Sheet. Once the data is received, then it can be parsed to separate fields.
Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel. New to VBA coding so having difficulty in making this work... below shows the code I have thus far but when run, it only extracts the first set of data but does not move onto the next block of text. In the Excel file I need: Description (company Name) | Speed (eg 1M) | Service Num. (7-digit number after the speed). The following is sample data present in the .txt file:
#
interface GigabitEthernet5/
vlan-type aser 7878
description ABC_COMPANY_1M_1254589_4444243
ip binding vpn-instance internet_vpn
ip address 158.214.125.215
#
interface GigabitEthernet5/0
vlan-type frin 2255
description XYZ_COMPANY_6M_1458963_444
ip binding vpn-instance internet_vpn
ip address 148.214.25.214
#
All data required comes after the 'interface GigabitEthernet' line (eg. Description: ABC_COMPANY | Speed: 1M | Service Num: 1254589)... there is also loads of data that comes before and after these blocks that does not need extracting.
The code below extracts correctly but does not move onto the next block of data required:
Appreciate any help with this... many thanks in advance.
POST MOVED BY MODERATOR
#
interface GigabitEthernet5/
vlan-type aser 7878
description ABC_COMPANY_1M_1254589_4444243
ip binding vpn-instance internet_vpn
ip address 158.214.125.215
#
interface GigabitEthernet5/0
vlan-type frin 2255
description XYZ_COMPANY_6M_1458963_444
ip binding vpn-instance internet_vpn
ip address 148.214.25.214
#
All data required comes after the 'interface GigabitEthernet' line (eg. Description: ABC_COMPANY | Speed: 1M | Service Num: 1254589)... there is also loads of data that comes before and after these blocks that does not need extracting.
The code below extracts correctly but does not move onto the next block of data required:
Appreciate any help with this... many thanks in advance.
POST MOVED BY MODERATOR