Get Windows Version from ISO files

Posted by cikul | Posted in Windows | Posted on 10-09-2014-05-2008

1

You want to install windows 7 pro 64 bit, and you had downloaded the ISO source from internet, but before install you’re not sure your ISO master is correct with your requirement (32 bit or maybe download Home edition).

Basically, any windows installation has WIM files within, Install.wim contains several sysprepped images of your Windows installation, and we can extract the information from install.wim to get the version of your installation.

Read the rest of this entry »

Share and Enjoy

[excel] Unprotect Excel Sheets without password

Posted by cikul | Posted in Windows | Posted on 02-09-2014-05-2008

0

Unprotect excel sheets can be done with VBA Macro.

To open VBA macro press ALT + F11, after Microsoft Visual Basic Open, press F5 to create new macro,

Insert this code :

Sub RemovePassword()
    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 "You can use the password to 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)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

To execute the macro press F5

The script will return output :

“You can use the password to unprotect : XFSTGAJHG”

The password provided can use to open sheets in same workbook which still protected.

Share and Enjoy

[Excel] Unhide Multiple Worksheet

Posted by cikul | Posted in Windows | Posted on 02-09-2014-05-2008

0

Excel allows us to hide multiple worksheet in one action, but not for unhide, we must unhide the sheets seperately, and it takes more time to do if we have many sheets that need to open.

The way to unhide all worksheets, we can use macro to do this job, this VBA macro will help you to unhide all worksheets in your excel documents.

To open VBA macro press ALT + F11, after Microsoft Visual Basic Open, press F5 to create new macro,

Sub UnhideSheets()
    Dim workSheet As Worksheet

    For Each workSheet In ActiveWorkbook.Worksheets
        workSheet.Visible = xlSheetVisible
    Next workSheet
End Sub

To execute the macro, press F5

Share and Enjoy

[Oracle] Troubleshoot “Connected to an idle instance.”

Posted by cikul | Posted in Linux, Oracle, SQL, Windows | Posted on 24-09-2012-05-2008

0

Problem : You have an Oracle instance, and you know it’s running on the system, when you’re trying to connect using “/ as sysdba” it says the instance is idle. You know the database is up and opened, because your application’s talking to it.


[oracle@server db_1]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 24 15:22:47 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>

Read the rest of this entry »

Share and Enjoy

How To Access OpenVPN using Windows, Linux, MAC OS X and Windows Mobile for Pocket PC

Posted by cikul | Posted in Free Stuff, Freeware, Linux, Technology, Tips, Windows | Posted on 10-11-2010-05-2008

9

The purpose of this document is to lead the users to configure theirs OpenVPN clients to access to a VPN server. We will see how to install and configure the most used OpenVPN’s GUI for Microsoft Windows, Linux, Mac OS X and Windows Mobile for Pocket PC. At the end of the document we will learn to use the OpenVPN’s command line interface. This last possibility is useful, because the openvpn command, which you can execute by using the prompt (Unix Shell or Windows Prompt) accepts the same parameters and has the same behavior regardless from which Operating System you use. In addition, you could use the openvpn command in a script to automatically start the VPN connection.

Read the rest of this entry »

Incoming search terms:

JAK SPRAWDZI PING | 

Share and Enjoy

tips : setup.exe always opened in notepad, how to solve this problem?

Posted by cikul | Posted in Windows | Posted on 31-12-2009-05-2008

3

Today I have problem in one of pc in my office, the problem is while we want to install something, and we try to execute file setup.exe or install.exe (default name for installation file), they don’t works  and notepad opened with ASCII code that i don’t understand what its mean.

Read the rest of this entry »

Share and Enjoy