N
N
Nighmer2020-04-23 13:04:15
MySQL
Nighmer, 2020-04-23 13:04:15

How to remove part of a request?

When creating several queries and then uploading them to an Excel sheet, you need to delete one of the queries.
The request and its unloading is carried out as follows

ActiveWorkbook.Worksheets.add
Sheets("IN").Select
With Sheets("IN").QueryTables.add(Connection:= _
"TEXT;" & PathFile _
, Destination:=Range("$A$5"))
'.CommandType = 0
.Name = FName
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = False
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 866
.TextFileStartRow = StartImportIndex + 2
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = False
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False


How to delete one of the requests?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question