Book tertutup

[Gilang]

Baimana caranya untuk mengambil data dari workbook yang tertutup?

 

[jolivanes]

Gilang.
You might get (more) responses if you formulate your questions in English. There are translation programs on the net if you need to use them.

More information is needed but the workbook needs to be opened which means we need to know the Path, Name of the Workbook, Sheet Name where to copy from as well as the range to copy.

This is a generic example of what it can look like.

Sub Maybe()
    Dim wb2 As Workbook
    Set wb2 = ThisWorkbook
    Application.ScreenUpdating = False
    Workbooks.Open ("C:\Folder Name Here\Workbook Name To Copy From Here.xlsm")
    Range("A1").CurrentRegion.Copy wb2.Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Offset(1)
    ActiveWorkbook.Close
    Application.ScreenUpdating = True
End Sub

 

[Michael M]

OR maybe post on out other Forum "Questions in other languages"

Questions in Other Languages

Ask any Excel questions in your native language (questions in languages other than English only, please).

www.mrexcel.com