求助EXCEL表用抓取多个表项中特定的值并汇总成一个

[精神小伙不请自来]

有多个如下的表格，我需要抓取到它的 IP、名称、Macaddress和Motherboard serial number 并汇整成一张表格


User Access Verification

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

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

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



This product contains cryptographic features and is subject to United
States and local country laws governing import, export, transfer and
use. 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
compliance with U.S. and local country laws. By using this product you
agree 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 please contact us by sending email to
[e-mail].

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

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


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


Configuration register is 0xF

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


User Access Verification

[吉祥编程]

你这不是表，是Txt文档吧，读取TXT文件的数据，请参考FSO对象。

更多Excel/VBA 知识，请关注 吉祥编程 公众号。

[精神小伙不请自来]

引用 1 楼 吉祥编程 的回复：

你这不是表，是Txt文档吧，读取TXT文件的数据，请参考FSO对象。

更多Excel/VBA 知识，请关注 吉祥编程 公众号。

哈哈，我直接汇入成excel表 ，用vba获取了，感觉还可以，