esteves.arthur
31-03-2022 16:07:35
Boa tarde! Pessoal, sou novo em VBA. Consegui com muito custo um código que lê o arquivo selecionado, traz ele bonitinho e ainda coloca o nome do TXT na aba, ou seja, funciona para um único arquivo. Contudo eu preciso selecionar vários arquivos. Tentei o MultiSelect e deu muito ruim. Fora que eu tentei colocar o While para fazer o mesmo processo junto com o multiselect e so deu erro. Conseguem me dar uma luz?
Option Explicit
Sub ImportarTXT()
Dim FilePath As String
Dim WorksheetName As String
Dim ws As Worksheet
Dim FileNameParts() As String
FilePath = BrowseFilePath("Arquivos do Text,*.txt", "Selecione os arquivos")
If FilePath = "" Then Exit Sub
Set ws = ActiveSheet
ws.Cells.Delete
With ws.QueryTables.Add(Connection:="TEXT;" & FilePath, _
Destination:=Range("A1"))
.TextFileTabDelimiter = True
.Refresh BackgroundQuery:=False
.Delete
End With
FileNameParts = Split(FilePath, "\")
WorksheetName = FileNameParts(UBound(FileNameParts))
WorksheetName = Left(WorksheetName, InStrRev(WorksheetName, ".") - 1)
ws.Name = WorksheetName
End Sub
Private Function BrowseFilePath(pFileFilter As String, pTitle As String) As String
Dim FilePath As String
FilePath = CStr(Application.GetOpenFilename(FileFilter:=pFileFilter, Title:=pTitle))
If FilePath = CStr(False) Then GoTo Quit
BrowseFilePath = FilePath
Quit:
End Function
Option Explicit
Sub ImportarTXT()
Dim FilePath As String
Dim WorksheetName As String
Dim ws As Worksheet
Dim FileNameParts() As String
FilePath = BrowseFilePath("Arquivos do Text,*.txt", "Selecione os arquivos")
If FilePath = "" Then Exit Sub
Set ws = ActiveSheet
ws.Cells.Delete
With ws.QueryTables.Add(Connection:="TEXT;" & FilePath, _
Destination:=Range("A1"))
.TextFileTabDelimiter = True
.Refresh BackgroundQuery:=False
.Delete
End With
FileNameParts = Split(FilePath, "\")
WorksheetName = FileNameParts(UBound(FileNameParts))
WorksheetName = Left(WorksheetName, InStrRev(WorksheetName, ".") - 1)
ws.Name = WorksheetName
End Sub
Private Function BrowseFilePath(pFileFilter As String, pTitle As String) As String
Dim FilePath As String
FilePath = CStr(Application.GetOpenFilename(FileFilter:=pFileFilter, Title:=pTitle))
If FilePath = CStr(False) Then GoTo Quit
BrowseFilePath = FilePath
Quit:
End Function