有多個如下的表格，我需要抓取到它的 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
[email protected].
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
uj5u.com熱心網友回復：
你這不是表，是Txt檔案吧，讀取TXT檔案的資料，請參考FSO物件。更多Excel/VBA 知識，請關注 吉祥編程 公眾號。
uj5u.com熱心網友回復：
哈哈，我直接匯入成excel表 ，用vba獲取了，感徑訓可以，轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/13531.html
標籤：VBA
上一篇：VBA如何操作網頁彈出的對話匡