Home > Software engineering >  Turn to EXCEL table with fetching multiple tables in item specific values and rolled into one
Turn to EXCEL table with fetching multiple tables in item specific values and rolled into one

Time:11-09

Have more than one the following form, I need to grab to its IP, name, Macaddress and Motherboard serial number, and compiled into a form


User Access Verification

Password:
TZNES - B11Z03 & gt; The enable
Password:
TZNES - B11Z03 # sh version
Cisco IOS Software, C2960 Software (C2960 - LANBASEK9 - M), Version 15.2 (2) the E7, RELEASE Software (fc3)
Technical Support: http://www.cisco.com/techsupport
Copyright (c) 1986-2017 by Cisco Systems, Inc.,
Compiled as Wed 12 Jul - 17 days by prod_rel_team

ROM: the Bootstrap program is C2960 boot loader
BOOTLDR: C2960 Boot Loader (C2960 - HBOOT - M) Version 15.0 (2 r) EZ1, RELEASE SOFTWARE (fc1)

TZNES - B11Z03 uptime is 27 weekes, 5 days, 13 hours, 49 minutes
The System returned to ROM by power - on
The System restarted at 09:53:03 GMT Tue Oct 1 2019
The System image file is "flash:/c2960 - lanbasek9 - mz. 152-2. E7/c2960 - lanbasek9 - mz. 152-2. E7. Bin"
The Last reload "reason: power - on



This product contains cryptographic features and is subject to United
States and the local country laws governing the import, export, transfer and
Use. The Delivery of Cisco cryptographic products does not imply
Third - party authority to import, export, distribute or use encryption.
Importers, exporters, distributors and users are responsible for
The compliance with U.S. and local country laws. By using this product you
Something to comply with applicable laws and regulations. If you are unable
To comply with U.S. and local laws, return this product immediately.

A summary of U.S. laws governing Cisco cryptographic products may be found at:
http://www.cisco.com/wwl/export/crypto/tool/stqrg.html

If you require further assistance both please contact us by sending email to
[email protected].

Cisco WS - C2960 + 48 TCS - L (PowerPC405) processor (revision J0) with 131072 k bytes of memory.
Processor board ID FOC2151Y3BX
The Last reset the from power - on
1 Virtual Ethernet interface
48 FastEthernet interface
2 Gigabit Ethernet interfaces
The password - recovery mechanism is enabled.

64 k bytes of flash - simulated non - volatile configuration memory.
Base Ethernet MAC Address: 00:3 C: yea: DA: 00
Motherboard the assembly number: 73-15619-01
The Power supply part number: 341-0097-03
Motherboard serial number: FOC215030CE
The Power supply serial number: DCA2148814R
The Model revision number: J0
Motherboard revision number: B0
Model number: WS - C2960 + 48 tc -l
The System serial number: FOC2151Y3BX
Top the Assembly Part Number: 800-40260-02
Top Assembly Revision Number: D0
Version ID: V02
CLEI Code Number: CMMKR00ARB
The Hardware Board Revision Number: 0 x0c


The Switch Ports Model SW Version SW Image
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
50 the WS - * 1 C2960 + 48 TCS - 15.2 L (2) E7 C2960 LANBASEK9 - M


The Configuration register is 0 xf

TZNES - B11Z03 # $
TZNES - B11Z03 # show run | include IP address
IP address 172.26.102.101 255.255.255.0


User Access Verification

CodePudding user response:

You this is not a table, is Txt documents, read Txt file data, please refer to the FSO object,

More Excel/VBA knowledge, pay attention to auspicious programming public,

CodePudding user response:

refer to the 1st floor programming reply:
this is not a table, you be Txt documents, read Txt file data, please refer to the FSO object,

More Excel/VBA knowledge, pay attention to good fortune, programming the public
ha ha, I import directly into Excel table, use VBA to obtain, feeling can also,
  •  Tags:  
  • VBA
  • Related