Website Para Ustadz

Kumpulan website resmi para ustadz-ustadz terpercaya, Insha Allah.

Googling atau Yufiding?

www.yufid.com adalah islamic search engine, atau mesin pencari ilmu-ilmu islam.

Sunnah Witir diluar Ramadan

“Wahai orang-orang yang cinta kepada Al-Qur’an, shalat witirlah, karena sesungguhnya Allah itu ganjil yang menyenangi (shalat) yang ganjil.” (Shahih: Shahih Ibnu Majah)

7 Orang Sukses Kuliah sambil Ngaji

Sukses Dunia Akhirat, Why Not?

Waktu-Waktu Terkabulnya Do'a

Jika bekerja pun ada waktu-waktu yang tepat,begitu pula dengan Do'a

Tuesday 4 April 2023

Gabung File Excel Menjadi Satu

 Cara menggabung beberapa file excel menjadi 1 file dengan beberapa sheet

Tekan Alt+F11 kemudian masukan comman berikut 


Sub MergeExcelFiles()

     Dim fnameList, fnameCurFile As Variant

     Dim countFiles, countSheets As Integer

     Dim wksCurSheet As Worksheet

     Dim wbkCurBook, wbkSrcBook As Workbook


     fnameList = Application.GetOpenFilename(FileFilter:="Microsoft Excel Workbooks (*.xls;*.xlsx;*.xlsm),*.xls;*.xlsx;*.xlsm", Title:="Choose Excel files to merge", MultiSelect:=True)


     If (vbBoolean <> VarType(fnameList)) Then


     If (UBound(fnameList) > 0) Then

     countFiles = 0

     countSheets = 0


     Application.ScreenUpdating = False

     Application.Calculation = xlCalculationManual


     Set wbkCurBook = ActiveWorkbook


     For Each fnameCurFile In fnameList

     countFiles = countFiles + 1


     Set wbkSrcBook = Workbooks.Open(Filename:=fnameCurFile)


     For Each wksCurSheet In wbkSrcBook.Sheets

     countSheets = countSheets + 1

     wksCurSheet.Copy after:=wbkCurBook.Sheets(wbkCurBook.Sheets.Count)

Next


     wbkSrcBook.Close SaveChanges:=False


     Next


     Application.ScreenUpdating = True

     Application.Calculation = xlCalculationAutomatic


     MsgBox "Processed " & countFiles & " files" & vbCrLf & "Merged " & countSheets & " worksheets", Title:="Merge Excel files"

     End If


     Else

     MsgBox "No files selected", Title:="Merge Excel files"

     End If

     End Sub



Selanjutnya Run, kemudian pilih file excel yang akan digabung dalam satu file namun dalam beberapa sheet. selanjutnya jika masing-masing sheet memiliki header yg sama kemudian akan kita gabung jadi 1 sheet maka kita gunakan rumus VBA seperti berikut, dengan menggunakan Alt+F11 lalu masukan script berikut 

Sub Combine()
'UpdateByKutools20151029
    Dim i As Integer
    Dim xTCount As Variant
    Dim xWs As Worksheet
    On Error Resume Next
LInput:
    xTCount = Application.InputBox("The number of title rows", "", "1")
    If TypeName(xTCount) = "Boolean" Then Exit Sub
    If Not IsNumeric(xTCount) Then
        MsgBox "Only can enter number", , "Kutools for Excel"
        GoTo LInput
    End If
    Set xWs = ActiveWorkbook.Worksheets.Add(Sheets(1))
    xWs.Name = "Combined"
    Worksheets(2).Range("A1").EntireRow.Copy Destination:=xWs.Range("A1")
    For i = 2 To Worksheets.Count
        Worksheets(i).Range("A1").CurrentRegion.Offset(CInt(xTCount), 0).Copy _
               Destination:=xWs.Cells(xWs.UsedRange.Cells(xWs.UsedRange.Count).Row + 1, 1)
    Next
End Sub



Maka semua sheet akan tergabung dalam 1 sheet dengan nama combined.

Sunday 9 February 2020

Gagal Instal Visio 2016

Pernah mau install visio tapi gagal dengan muncul tulisan

click to run installer based office programs installed on your computer
office 16 click-to-run extensibility component error

Solusi pertama uninstall dulu office 16 click to run di PC kamu

Saya ambil dari link berikut 
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_install-mso_win10/office-16-click-to-run-extensibility-component-64/e79ee5bd-f119-4808-9bb2-289dd815b76a

To completely uninstall your Office applications, we suggest you use the “easy fix” tool from this article.

To uninstall Office 16 Click-to-Run Extensibility Component 64-bit Registration, please try the steps below:
1. Press Win + R to open the Run window, type “installer” and click Enter to open the folder in File Explorer.
2. Add the column “Subject”. Right click the column headers, then click More and select Subject
3. Sort on the Subject column and scroll down until you locate the name “Office 16 Click-to-Run Extensibility Component 64-bit Registration”.
4. Right click the MSI file and choose uninstall.


Solusi kedua, adalah tambah registry dimenu regedit

1. Go to the registry path HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\
Windows\CurrentVersion\Uninstall\Office16.PROPLUS (x86 Office) or HKEY_CURRENT_USER\Software\Microsoft\Windows\
CurrentVersion\Uninstall\Office16.PROPLUS (x64 Office)
2. Add a DWORD value called SystemComponent and set it to 1
3. Now make sure that in the control panel (Programs and Features) Office 2016 is absent
4. You can install Visio 2016 now with the C2R installer, after that start it and enter your serial

5. Remove the registry value from step 2 so that the Office 2016 entry appears again

Kalau ada pertanyaan silahkan tanya2 saya di fb.com/sukrya atau Instagram dan twitter @hasbulahasan or Whatsapp o8537777I0I6

Friday 17 May 2019

Solusi Add-Ins Terbilang tidak Permanen di Office 2016

Pada excel 2016, saya menemukan masalah harus selalu menyetel ulang -add in- fungsi terbilang 'setiap masuk excel.

Alhamdulillah, saya sudah menemukan solusinya agar 'fungsi terbilang' bisa aktif permanen di excel 2016, yaitu dengan klik kanan file .XLAM terbilang yang sudah anda download lalu pilih properties.


Selanjutnya dibawah Advance akan ada tulisan Unblock lalu tekan centang pada Unblock kemudian "Apply". Dengan cara itu 'fungsi terbilang' di excel 2016 saya tetap aktif permanen.

Sumber : SugihWibawa Utama (Microsoft Answer)