I have the folowing macro to open a CSV file and clear data in specific columns
The worbook that the macro resides in is in folder C:\My Documents
It would be appreciated if my code can be amended so that folder C:\Downloads is selected as the the CSV file has been downloaded in this folder
Your assistance in this regard is most appreciated
The worbook that the macro resides in is in folder C:\My Documents
It would be appreciated if my code can be amended so that folder C:\Downloads is selected as the the CSV file has been downloaded in this folder
Code:
Sub Open_911810_CSV()
Dim ws As Worksheet, File As String
File = Dir(ThisWorkbook.Path & "\*911810*.csv")
Set ws = Workbooks.Open(File).ActiveSheet
ActiveSheet.UsedRange.Columns("A:D").Offset(1).Clear
End Sub
Your assistance in this regard is most appreciated