What changes do I need to make to point to the directory path( hardcode path) but let the user select one csv file
to read and process
Dim f As object
Dim varItem as Variant
Set f=Application.FileDialog(3)
f.AllowMultiSelect= True
If f.show Then
For each VarItem In f.SelectedItems
StrFilename = Di(VarItem)
StrilePath = StrInfie& Strfilename
Next
End If
For Ex: Directory= c:\temp\CsvFiles
Thank you