Sub LoadUpLoad() ' ' LoadUpLoad Macro ' Carica da txt Load giornaliero ' FullNome = Application.GetOpenFilename("Text Files (*.txt),*.text", Title:="Select file") With ActiveSheet.QueryTables.Add(Connection:=FullNome, Destination:=Range("$U$5:$U$28")) .Name = "FullNome" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlOverwriteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = False .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = 850 .TextFileStartRow = 1 .TextFileParseType = xlFixedWidth .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(1) .TextFileTrailingMinusNumbers = True .Refresh BackgroundQuery:=False End With End Sub |
With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & FullNome, estination:=Range("$U$5:$U$28")) |
Sub OpenText_dialog() Dim strFile As String, strPath As String cartellainiziale = "C:Documenti" ' <<<<<<<<< da cambiare With Application.FileDialog(msoFileDialogOpen) .InitialFileName = cartellainiziale .Title = "Seleziona cartella e File" .AllowMultiSelect = False .Show If .SelectedItems.Count = 0 Then Exit Sub sFile = .SelectedItems(1) End With Workbooks.OpenText sFile, Local:=True End Sub |
With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & FullNome, estination:=Range("$U$5:$U$28")) |
Dim strFile As String, strPath As String Set sh = ActiveSheet cartellainiziale = "F:Download" ' <<<<<<<<< da cambiare With Application.FileDialog(msoFileDialogOpen) .InitialFileName = cartellainiziale .Title = "Seleziona cartella e File" .AllowMultiSelect = False .Show If .SelectedItems.Count = 0 Then Exit Sub sFile = .SelectedItems(1) End With Workbooks.OpenText sFile, Local:=True ActiveSheet.UsedRange.Copy sh.Range("A1") ActiveWorkbook.Close False End Sub |