Assalamualaikum War. Wab
Mau tanya, kira2 apa yang kurang?, nyimpan ke file lain dari baris 4 sampai 23 tidak bisa, mohon pencerahannya dan kami lampirkan filenya.
Terimakasih sebelumnya.
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
If IsFileOpen("G:\TEST\Data.xlsx") Then
MsgBox "Maaf, file 1.xlsx sedang dibuka, silahkan tutup file terlebih dahulu.."
Exit Sub
End If
Workbooks.Open FileName:="G:\TEST\Data.xlsx"
With Worksheets("Sheet1")
BarisTerakhir = .Cells(.Rows.Count, 1).End(xlUp).Row
For i = 1 To 8
.Cells(BarisTerakhir + 1, i).Value = Me.Cells(4, i).Value
Next i
End With
Workbooks("Data.xlsx").Save
Workbooks("Data.xlsx").Close
Application.ScreenUpdating = True
End Sub
Function IsFileOpen(FileName As String)
Dim iFilenum As Long
Dim iErr As Long
On Error Resume Next
iFilenum = FreeFile()
Open FileName For Input Lock Read As #iFilenum
Close iFilenum
iErr = Err
On Error GoTo 0
Select Case iErr
Case 0: IsFileOpen = False
Case 70: IsFileOpen = True
Case Else: Error iErr
End Select
End Function