掛載ISCSI目標至目錄

  • Category: 電腦相關
  • Last Updated: Thursday, 13 March 2014 22:00
  • Published: Thursday, 13 March 2014 13:52
  • Written by sam

因為使用的NAS網路磁碟無法直接掛載成WINDOWS目錄

所以只好再建立使用ISCSI的方式來掛載

OS = WINDOWS 2003 R2 SP2

預設是沒有Microsoft iSCSI Initiator

需要先行下載、安裝

之後就很簡單了…照著圖作設定(當然在ISCSI端要先設定好,我是設定使用帳號認證)

安裝完打開的畫面

 photo 2014-03-07_085559_zpsef6a5ead.jpg

Read more: 掛載ISCSI目標至目錄

Excel 保護工作表 vba保護

  • Category: 電腦相關
  • Last Updated: Friday, 17 January 2014 16:37
  • Published: Thursday, 26 December 2013 10:33
  • Written by sam

常常許多單位的交換資料

都會順手加上保護防止複製…

excel 2007

開文件 檢視 巨集 錄製巨集 出現視窗 隨便取個名字 離開

點開巨集 檢視巨集 編輯剛剛的巨集 替換掉所有內容

Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

離開 

再點 巨集 檢視巨集 然後選執行

就成了

Read more: Excel 保護工作表 vba保護

PPTP VPN 架設 FEDORA

  • Category: 電腦相關
  • Last Updated: Thursday, 01 May 2014 14:07
  • Published: Wednesday, 25 December 2013 11:22
  • Written by sam

小部門沒有VPN可以使用

試著自己動手

看了一下資料也不難

順手抓一隻現有的LINUX來弄,應該就行

剛好看到有臺FEDORA閒在那邊…

架構如下

WAN-FW-FEDORA-OA

使用的是單網卡架構(因為沒有多的網卡…

首先就是要確認一下OS是什麼…幾位元…版本

[root@moon sysconfig]# file /bin/bash

/bin/bash: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9, stripped

這樣就能看出是32bit的了

[root@moon sysconfig]# uname -r

Read more: PPTP VPN 架設 FEDORA