2023年6月18日 星期日

Hiding Columns in Excel

 https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Hiding-Columns-in-Excel/td-p/2005312


Hiding Columns in Excel

Select cell

Send keys {Control}({Space}) 'this will select the column

Send keys {Control}(0) 'this will hide the column


=> {LControlKey}({D0})

張貼者： 於 沒有留言:

2023年6月16日 星期五

pip install PyPdf2==2.12.1

 https://github.com/camelot-dev/camelot/issues/339



pip install PyPdf2==2.12.1

Collecting PyPdf2==2.12.1

  Downloading pypdf2-2.12.1-py3-none-any.whl (222 kB)

     |████████████████████████████████| 222 kB 6.8 MB/s

Requirement already satisfied: typing_extensions>=3.10.0.0; python_version < "3.10" in c:\programdata\anaconda3\lib\site-packages (from PyPdf2==2.12.1) (4.6.3)

Installing collected packages: PyPdf2

Successfully installed PyPdf2-2.12.1

張貼者： 於 沒有留言:

2023年5月25日 星期四

upgrade c1000

 https://www.manageengine.com/network-configuration-manager/configlets/cisco-ios-firmware-upgrade.html

張貼者： 於 沒有留言:

2023年5月11日 星期四

Lightweight to Autonomous (vice versa) Conversion…

mrncciew https://mrncciew.com/2012/10/20/lightweight-to-autonomous-conversion/


efore converting LWAP to Autonomous need to understand the type of OS image running on these platforms. I found following blog post is very useful to summarize the type of IOS & understanding its naming convention.

http://www.my80211.com/cisco-auton-labs/2011/11/19/understanding-cisco-access-point-ios-images.html

Following are the three type of IOS available & need to download the correct type before starting the conversion process.

  • k9w7 – autonomous IOS
  • k9w8 – full lightweight IOS (this is what is bundled in the WLC .aes image, and is factory installed on “mesh” APs)
  • rcvk9w8 – lightweight recovery image – this is factory installed on lightweight APs, unless a “mesh” image is specified; it lacks radio firmware

In our case we require k9w7 for Autonomous conversion. More specifically c1140-k9w7-tar.124-25d.JA.tar as my AP is 1142.

To convert Lightweight AP to Autonomous AP, need to have PC directly connected to AP’s ethernet port. If you are powering AP from the switch (i.e use PoE) then PC & AP needs to be in two switch ports in the same vlan. In my example PC is 10.10.10.1/24 & AP is 10.10.10.102/24.

Console into the access point & do the following configurations.

AP5475.d0f5.2ee7#sh ip int brief
Interface                  IP-Address      OK? Method Status                Protocol
Dot11Radio0                unassigned      NO  unset  up                    up      
Dot11Radio1                unassigned      NO  unset  up                    up      
GigabitEthernet0           unassigned      YES DHCP   up                  up  

AP5475.d0f5.2ee7#debug capwap console cli   <- without this line LWAP not accepting the conf t

AP5475.d0f5.2ee7#conf t
AP5475.d0f5.2ee7(config)#ip default-gateway 10.10.10.1
AP5475.d0f5.2ee7(config)#int g0
AP5475.d0f5.2ee7(config-if)#ip address 10.10.10.102 255.255.255.0
AP5475.d0f5.2ee7(config-if)#no sh

AP5475.d0f5.2ee7#ping 10.10.10.1
Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 10.10.10.1, timeout is 2 seconds: !!!!!

AP5475.d0f5.2ee7#archive download-sw /force-reload /overwrite tftp://10.10.10.1/c1140-k9w7-tar.124-25d.JA.tar

"examining image...
 Loading c1140-k9w7-tar.124-25d.JA.tar from 10.10.10.1 (via GigabitEthernet0): !
 extracting info (283 bytes)
 Image info:
     Version Suffix: k9w7-.124-25d.JA ...................."

Once conversion process is over, you can verify the right image is on your access point.

ap>en
  Password:  <-- default password is Cisco
  ap#
  ap#sh version
  Cisco IOS Software, C1140 Software (C1140-K9W7-M), Version 12.4(25d)JA, RELEASE SOFTWARE (fc1)
  Technical Support: http://www.cisco.com/techsupport
  Copyright (c) 1986-2010 by Cisco Systems, Inc.
  Compiled Thu 09-Dec-10 15:24 by prod_rel_team
ROM: Bootstrap program is C1140 boot loader
  BOOTLDR: C1140 Boot Loader (C1140-BOOT-M) Version 12.4(18a)JA3, RELEASE SOFTWARE (fc1)
ap uptime is 0 minutes
  System returned to ROM by reload
  System image file is "flash:/c1140-k9w7-mx.124-25d.JA/c1140-k9w7-mx.124-25d.JA"

For the LWAP conversion, use the recovery image ( e.g  c1140-rcvk9w8-tar.124-25d.JAL.tar). We can use the same command on the autonomous AP priviledge mode.

AP5475.d0f5.2ee7#archive download-sw /force-reload /overwrite tftp://10.10.10.1/c1140-rcvk9w8-tar.124-25d.JA.tar

Following Cisco Support Community forum video demonstrate teh above process.

https://supportforums.cisco.com/videos/

If you have WLC managed AP (currently registered to a WLC), then you can use WLC CLI command to convert that to Autonomous. In below example I have IW3702 AP on my WLC

(8540-TEST) >show ap summary
AP Name Slots AP Model Ethernet MAC Location Country IP Address
IW3702 2 IW3702-2E-Z-K9 2c:d0:2d:81:a6:5c default location AU 10.15.6.90
(WLC) >config ap tftp-downgrade ? 
<TFTP Server IP addr> Enter the TFTP server's IP address

(WLC) >config ap tftp-downgrade x.x.x.x ? 
<filename> Image file name on the TFTP server

(WLC) >config ap tftp-downgrade x.x.x.x ap3g2-k9w7-tar.153-3.JE.tar ?
<Cisco AP> Enter the name of the Cisco AP.
 
(WLC) >config ap tftp-downgrade x.x.x.x ap3g2-k9w7-tar.153-3.JE.tar IW3702

Once issue that command given AP should download new image from your TFTP server.efore converting LWAP to Autonomous need to understand the type of OS image running on these platforms. I found following blog post is very useful to summarize the type of IOS & understanding its naming convention.

http://www.my80211.com/cisco-auton-labs/2011/11/19/understanding-cisco-access-point-ios-images.html

Following are the three type of IOS available & need to download the correct type before starting the conversion process.

  • k9w7 – autonomous IOS
  • k9w8 – full lightweight IOS (this is what is bundled in the WLC .aes image, and is factory installed on “mesh” APs)
  • rcvk9w8 – lightweight recovery image – this is factory installed on lightweight APs, unless a “mesh” image is specified; it lacks radio firmware

In our case we require k9w7 for Autonomous conversion. More specifically c1140-k9w7-tar.124-25d.JA.tar as my AP is 1142.

To convert Lightweight AP to Autonomous AP, need to have PC directly connected to AP’s ethernet port. If you are powering AP from the switch (i.e use PoE) then PC & AP needs to be in two switch ports in the same vlan. In my example PC is 10.10.10.1/24 & AP is 10.10.10.102/24.

Console into the access point & do the following configurations.

AP5475.d0f5.2ee7#sh ip int brief
Interface                  IP-Address      OK? Method Status                Protocol
Dot11Radio0                unassigned      NO  unset  up                    up      
Dot11Radio1                unassigned      NO  unset  up                    up      
GigabitEthernet0           unassigned      YES DHCP   up                  up  

AP5475.d0f5.2ee7#debug capwap console cli   <- without this line LWAP not accepting the conf t

AP5475.d0f5.2ee7#conf t
AP5475.d0f5.2ee7(config)#ip default-gateway 10.10.10.1
AP5475.d0f5.2ee7(config)#int g0
AP5475.d0f5.2ee7(config-if)#ip address 10.10.10.102 255.255.255.0
AP5475.d0f5.2ee7(config-if)#no sh

AP5475.d0f5.2ee7#ping 10.10.10.1
Type escape sequence to abort.
Sending 5, 100-byte ICMP Echos to 10.10.10.1, timeout is 2 seconds: !!!!!

AP5475.d0f5.2ee7#archive download-sw /force-reload /overwrite tftp://10.10.10.1/c1140-k9w7-tar.124-25d.JA.tar

"examining image...
 Loading c1140-k9w7-tar.124-25d.JA.tar from 10.10.10.1 (via GigabitEthernet0): !
 extracting info (283 bytes)
 Image info:
     Version Suffix: k9w7-.124-25d.JA ...................."

Once conversion process is over, you can verify the right image is on your access point.

ap>en
  Password:  <-- default password is Cisco
  ap#
  ap#sh version
  Cisco IOS Software, C1140 Software (C1140-K9W7-M), Version 12.4(25d)JA, RELEASE SOFTWARE (fc1)
  Technical Support: http://www.cisco.com/techsupport
  Copyright (c) 1986-2010 by Cisco Systems, Inc.
  Compiled Thu 09-Dec-10 15:24 by prod_rel_team
ROM: Bootstrap program is C1140 boot loader
  BOOTLDR: C1140 Boot Loader (C1140-BOOT-M) Version 12.4(18a)JA3, RELEASE SOFTWARE (fc1)
ap uptime is 0 minutes
  System returned to ROM by reload
  System image file is "flash:/c1140-k9w7-mx.124-25d.JA/c1140-k9w7-mx.124-25d.JA"

For the LWAP conversion, use the recovery image ( e.g  c1140-rcvk9w8-tar.124-25d.JAL.tar). We can use the same command on the autonomous AP priviledge mode.

AP5475.d0f5.2ee7#archive download-sw /force-reload /overwrite tftp://10.10.10.1/c1140-rcvk9w8-tar.124-25d.JA.tar

Following Cisco Support Community forum video demonstrate teh above process.

https://supportforums.cisco.com/videos/

If you have WLC managed AP (currently registered to a WLC), then you can use WLC CLI command to convert that to Autonomous. In below example I have IW3702 AP on my WLC

(8540-TEST) >show ap summary
AP Name Slots AP Model Ethernet MAC Location Country IP Address
IW3702 2 IW3702-2E-Z-K9 2c:d0:2d:81:a6:5c default location AU 10.15.6.90
(WLC) >config ap tftp-downgrade ? 
<TFTP Server IP addr> Enter the TFTP server's IP address

(WLC) >config ap tftp-downgrade x.x.x.x ? 
<filename> Image file name on the TFTP server

(WLC) >config ap tftp-downgrade x.x.x.x ap3g2-k9w7-tar.153-3.JE.tar ?
<Cisco AP> Enter the name of the Cisco AP.
 
(WLC) >config ap tftp-downgrade x.x.x.x ap3g2-k9w7-tar.153-3.JE.tar IW3702

Once issue that command given AP should download new image from your TFTP server.

張貼者： 於 沒有留言:
標籤： , ,

2023年5月9日 星期二

TinyTask

 https://www.prohavit.com/blogs/havit/8-free-macro-recorder-that-automate-your-traditional-mouse-and-keyboard?currency=HKD

 TinyTasks

These are among the small macro recorder software available, with a capacity about 33KB. Majorly it is known for playback and recording functionalities. TinyTasks have only six buttons for all its purposes hence simple to use.

 

Pros:

  • Easy to use
  • Simple interface
  • Can record mouse and keyboard inputs
  • Can compile to .exe file

Cons:

  • Limited features

張貼者： 於 沒有留言:

2023年5月3日 星期三

how-to-configure-dhcp-server-on-cisco-switches.html

 Switch>enable

Switch#configure terminal
Switch(config)#ip dhcp excluded-address 192.168.1.1 192.168.1.10
Switch(config)#ip dhcp pool test
Switch(dhcp-config)#network 192.168.1.0 255.255.255.0
Switch(dhcp-config)#default-router 192.168.1.1
Switch(dhcp-config)#dns-server 4.4.4.4
Switch(dhcp-config)#exit
Switch(config)#interface vlan 1
Switch(config-if)#ip address 192.168.1.5  255.255.255.0
Switch(config-if)#no shutdown
Switch(config-if)#exit
Switch(config)#exit
Switch#

https://www.computernetworkingnotes.com/ccna-study-guide/
張貼者： 於 沒有留言:
標籤： ,

2023年2月13日 星期一

Where is the Scroll Lock key on Inspiron15? for Excel scroll locked but using Dell notebook without connect External Keyboard

 Where is the Scroll Lock key on Inspiron15?

I cannot play online games on my new inspiron because every time i use the arrow keys the screen moves, so do you guys know where the scroll lock key is on the laptop or how to stop this from happening

2 people had this problem.
 
Solution (1)
4 Tellurium
125172
‎11-24-2011 06:08 PM

Try Microsofts "On Screen keyboard" utility

1.Click the START button

2.Type osk (make sure that osk.exe is high lighted if you get more than one option)

3.Press ENTER.

4.Activate "ScrLK"

5.Be happy if it works..............



There are different ways to scroll through a worksheet. You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet.

In Excel, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and ScreenTips that let you know where you are in the worksheet. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars.

張貼者： 於 沒有留言:
標籤： ,
訂閱： 文章 (Atom)