Feeds:
Posts
Comments

DOS Prompt Command

  • map network path to local network drive

net use I: \\128.1.1.1\C$ /user:admin “password”

  • disconnect local network drive

net use I: /delete

The above DOS command has same effect as the function provided in Window Explorer.

  • Map Network Drive
  • Disconnect
  1. Install VC 6
  2. Edit sp598ent.stf to skip checking MDCA
  3. Install VC6 SP5 (setupsp5.exe)
  4. Install MQ 7.1
  5. Set options in VC6 for adding include and directories for MQ
  6. Modify Environment to include following: MQCCSID 950, MQCHLLIB C:\Ocp\Import, MQCHLTAB AMQCLCHL.TAB

DVD drive used over the network

  • make sure that enable sharing for DVD drive
  • make sure that the sharing permission is for everyone to read

Computers in same network

  • make sure that they are in same WORKGROUP
  • make sure that the firewall is disable for file and printer sharing

References

BitLocker To Go

The Feature “Turn On Bitlocker To Go” is available in Windows 7 Ultimate and Enterprise, Windows 8.1 Professional and above, and Windows 10 Professional above

Reference

http://www.techrepublic.com/blog/windows-and-office/secure-your-usb-drives-with-bitlocker-to-go-for-windows-7/

Const NUM_FARE_TYPE = 4
Dim SrcSheet(1 To 4) As String

Sub Initialize

SrcSheet(1) = “AduSR”
SrcSheet(2) = “ConSR”
SrcSheet(3) = “AduSR_1C”
SrcSheet(4) = “ConSR_1C”

End Sub
Sub Copy1a1b()

‘ Copy1a1b Macro

Const NUM_SET = 2
Const SET1_SRC = 10
Const SET2_SRC = 51

Const SET1_DEST_ADUSR = 9
Const SET2_DEST_ADUSR = 77
Const SET1_NUM_STAT = 17
Const SET2_NUM_STAT = 6

Dim i, j, k, m As Integer
Dim SetSrc(1 To NUM_SET), SetDest(1 To NUM_SET), SetNumStat(1 To NUM_SET) As Integer

SetSrc(1) = SET1_SRC
SetSrc(2) = SET2_SRC

SetDest(1) = SET1_DEST_ADUSR
SetDest(2) = SET2_DEST_ADUSR

SetNumStat(1) = SET1_NUM_STAT
SetNumStat(2) = SET2_NUM_STAT

Initialize

‘ SHEET “1a. ISL + TKL: BEGIN
Windows(“2016 Worksheets.xlsx”).Activate
Sheets(“1a.ISL+TKL >”).Select

‘ To ISL: BEGIN
For k = 1 To NUM_FARE_TYPE
Windows(“2016_ (Test).xlsx”).Activate
Sheets(SrcSheet(k)).Select

For m = 1 To NUM_SET
j = SetDest(m) + k – 1
For i = 1 To SetNumStat(m)
Windows(“2016_(Test).xlsx”).Activate
Range(“G” & (SetSrc(m) + i – 1) & “:W” & (SetSrc(m) + i – 1)).Select
Selection.Copy
Windows(“2016 Worksheets.xlsx”).Activate
Range(“H” & j).Select
ActiveSheet.Paste
j = j + 4
Next i
Next m

Next k
‘ To ISL: END

‘ To TWL: BEGIN
For k = 1 To NUM_FARE_TYPE
Windows(“2016_(Test).xlsx”).Activate
Sheets(SrcSheet(k)).Select

For m = 1 To NUM_SET
j = SetDest(m) + k – 1
For i = 1 To SetNumStat(m)
Windows(“2016_(Test).xlsx”).Activate
Range(“X” & (SetSrc(m) + i – 1) & “:AK” & (SetSrc(m) + i – 1)).Select
Selection.Copy
Windows(“2016 Worksheets.xlsx”).Activate
Range(“Y” & j).Select
ActiveSheet.Paste
j = j + 4
Next i
Next m

Next k
‘ To TWL: END

==========================================================================
End Sub

 

useful software tool

  1. Capture screen: Greenshot
  2. File Transfer: FileZilla
  3. MTTTY: Multi-threaded Terminal Sample (Win32)
  4. usbview.exe
  5. mysql-connector-odbc-5.3.4-win32.msi
  6. PuTTY putty.exe
  7. teraterm
  8. winscp
  9. HxD Hex Editor
  10. Q-Dir_portable (Q-Dir.exe)
  11. ruby185-21.exe
  12. TrueCrypt
  13. unix2dos.exe
  14. Window Mobile Device Centre (for HHC)
  15. VMware-player-6.0.4-2249910.exe
  16. WinMerge
  17. VirtualBox
  18. Notepad++
  19. tinytask
  20. audacity

find . -name “*” -exec dos2unix {} \;