NK TYE LA MCM MANE NK EXPORT FILE .txt KE .xls BILA TEKAN CMD BUTTON????
Spe ley bntu??
johnburn wrote:format dlm text file tu cmne?
putri wrote:SALAM SUMER...
NK TYE LA MCM MANE NK EXPORT FILE .txt KE .xls BILA TEKAN CMD BUTTON????
Spe ley bntu??
chaer89 wrote:kna wat link la.
chaer89 wrote:klo xslap la..
pkai ADODC ada tool bar 2..
lpa dah
iluvkarim.selamat wrote:What they mean is, the txt content, is it in CSV or other format.
DevGuy wrote:ada cara senang.content utk txt file tu apa.cuba kasi sample sikit.senang orang nak tolong
kalau guna .net kita leh export terus text file tu ker excel
ok
iluvkarim.selamat wrote:Can you attach a sample of the .dat file.
That might clear things up.
johnburn wrote:format dlm text file tu cmne?
DevGuy wrote:ada cara senang.content utk txt file tu apa.cuba kasi sample sikit.senang orang nak tolong
kalau guna .net kita leh export terus text file tu ker excel
ok
iluvkarim.selamat wrote:Can you attach a sample of the .dat file.
That might clear things up.
DevGuy wrote:kasi aaa sample sikit biar orang senang nak tolong. hadus. kalau tak derr tak dapat aa den nak tolong yekkk
Hehe, tujuan ktorng mntk ni sbb nk tgk frmt data dlm text file tu untk memudahkn pengmbilan data.iluvkarim.selamat wrote:adeh. sample la, not the actual file.
Public Sub ImportText(namaFile As String, pemisah As String)
Dim baris As Long
Dim lajur As Integer
Dim TempVal As Variant
Dim WholeLine As String
Dim Pos As Integer
Dim NextPos As Integer
Dim Savelajur As Integer
Application.ScreenUpdating = False
'On Error GoTo EndMacro:
Savelajur = ActiveCell.Column
baris = ActiveCell.Row
Open namaFile For Input Access Read As #1
While Not EOF(1)
Line Input #1, WholeLine
If Right(WholeLine, 1) <> pemisah Then
WholeLine = WholeLine & pemisah
End If
lajur = Savelajur
Pos = 1
NextPos = InStr(Pos, WholeLine, pemisah)
While NextPos >= 1
TempVal = Mid(WholeLine, Pos, NextPos - Pos)
Cells(baris, lajur).Value = TempVal
Pos = NextPos + 1
lajur = lajur + 1
NextPos = InStr(Pos, WholeLine, pemisah)
Wend
baris = baris + 1
Wend
EndMacro:
On Error GoTo 0
Application.ScreenUpdating = True
Close #1
End Sub
Sub ImportFileSetPemisah()
Dim FileName As Variant
Dim pemisah As String
FileName = Application.GetOpenFilename(FileFilter:="Text File (*.txt),*.txt")
If FileName = False Then
Exit Sub
End If
pemisah = Application.InputBox("Masukkan aksara pemisah.", Type:=2)
If pemisah = vbNullString Then
Exit Sub
End If
Debug.Print "Nama Fail: " & FileName, "Pemisah: " & pemisah
ImportText namaFile:=CStr(FileName), pemisah:=CStr(pemisah)
End Sub
DevGuy wrote:kasi aaa sample sikit biar orang senang nak tolong. hadus. kalau tak derr tak dapat aa den nak tolong yekkk
Guest wrote:adeh. sample la, not the actual file.
johnburn wrote:johnburn wrote:format dlm text file tu cmne?DevGuy wrote:ada cara senang.content utk txt file tu apa.cuba kasi sample sikit.senang orang nak tolong
kalau guna .net kita leh export terus text file tu ker excel
okiluvkarim.selamat wrote:Can you attach a sample of the .dat file.
That might clear things up.DevGuy wrote:kasi aaa sample sikit biar orang senang nak tolong. hadus. kalau tak derr tak dapat aa den nak tolong yekkkHehe, tujuan ktorng mntk ni sbb nk tgk frmt data dlm text file tu untk memudahkn pengmbilan data.iluvkarim.selamat wrote:adeh. sample la, not the actual file.
Dalam contoh kod diatas, namaFile tu merupakan nama text file yg nk di import ke dlm excel. ko bleh spesifikkn data dlm text file tu dipisahkan oleh apa, sebagai cnth, kl dlm text file tu data die cmni:
- Code:
Public Sub ImportText(namaFile As String, pemisah As String)
Dim baris As Long
Dim lajur As Integer
Dim TempVal As Variant
Dim WholeLine As String
Dim Pos As Integer
Dim NextPos As Integer
Dim Savelajur As Integer
Application.ScreenUpdating = False
'On Error GoTo EndMacro:
Savelajur = ActiveCell.Column
baris = ActiveCell.Row
Open namaFile For Input Access Read As #1
While Not EOF(1)
Line Input #1, WholeLine
If Right(WholeLine, 1) <> pemisah Then
WholeLine = WholeLine & pemisah
End If
lajur = Savelajur
Pos = 1
NextPos = InStr(Pos, WholeLine, pemisah)
While NextPos >= 1
TempVal = Mid(WholeLine, Pos, NextPos - Pos)
Cells(baris, lajur).Value = TempVal
Pos = NextPos + 1
lajur = lajur + 1
NextPos = InStr(Pos, WholeLine, pemisah)
Wend
baris = baris + 1
Wend
EndMacro:
On Error GoTo 0
Application.ScreenUpdating = True
Close #1
End Sub
data1, data2, data3
So ko bleh nmpk data dlm file text tu dipisahkan oleh koma. untuk memudahkn ko pilih file dan spesifikkan pemisah untuk data, bleh pkai ni:
- Code:
Sub ImportFileSetPemisah()
Dim FileName As Variant
Dim pemisah As String
FileName = Application.GetOpenFilename(FileFilter:="Text File (*.txt),*.txt")
If FileName = False Then
Exit Sub
End If
pemisah = Application.InputBox("Masukkan aksara pemisah.", Type:=2)
If pemisah = vbNullString Then
Exit Sub
End If
Debug.Print "Nama Fail: " & FileName, "Pemisah: " & pemisah
ImportText namaFile:=CStr(FileName), pemisah:=CStr(pemisah)
End Sub
LastName,FirstName,MiddleInitial
Myer,Ken,W
Poe, Deborah,L