CSV file not importing unless opened and saved

[UNKGuy]

I have a macro that is supposed to import a downloaded csv file into a worksheet in my primary workbook. Currently, it only imports the csv file if it has been opened and saved before importing. I apologize in advance if this has been answered in previous posts, but I couldn't find the right keywords to find the information I was looking. The code below is what I am using.

Sub Import_DX()

Dim f as Variant

f = Application.GetOpenFilename(filefilter:="CSV Files (*.csv), *.csv")

If f = "False" Then Exit Sub

With Worksheets("DX Import").QueryTables.Add(Connection:= _
"TEXT;" & f, Destination:=Worksheets("DX Import").Range("$A$1"))
.Name = "DXI"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 1252
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = False
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(9, 1, 1, 9, 1, 1, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
End With

End Sub

Respectfully

 

[ZVI]

Hi and welcome to MrExcel board!
Not sure but try: .RefreshOnFileOpen = True
Hope this helps

 

[UNKGuy]

Vladimir,

Thank you for the response. I changed it to true, but it prompts for prior connections. On another project I was working on I was able to make the connection persistent and that worked out well, but with this one, the downloaded csv will have a different name each day, and possibly saved in a different place depending on who downloads it. I have no idea why I would need to open and save the csv before it imports. Any other thoughts?

Respectfully

 

[ZVI]

...I have no idea why I would need to open and save the csv before it imports. Any other thoughts?

Usually resaving is required for downloaded files in Protected View mode.
Try to disable Protected View for a while to check it is the reason.
For that purpose in Excel - File - Options - Trust Center - Trust Center Settings - Protected View
try to uncheck all checkboxes.