Hi
I've got some VBA code which opens the downloads folder.
But once I've done that, I'd like to select that file and import data from column A - C in it into my active workbook.
Does anyone know how I can modify the code below, please, to transfer data between the workbooks?
I haven't done this in a while - hence the reason I'm asking!
TIA
I've got some VBA code which opens the downloads folder.
But once I've done that, I'd like to select that file and import data from column A - C in it into my active workbook.
Does anyone know how I can modify the code below, please, to transfer data between the workbooks?
I haven't done this in a while - hence the reason I'm asking!
TIA
VBA Code:
Sub OpenDownloadsFolder()
Dim fd As FileDialog
Dim filewaschosen As Boolean
Dim Report As Workbook
Dim iWB As Workbook
Set Report = ActiveWorkbook
Set fd = Application.FileDialog(msoFileDialogOpen)
fd.Filters.Clear
fd.Filters.Add "xlsx files", "*.xlsx"
fd.AllowMultiSelect = False
fd.InitialFileName = Environ("UserProfile") & "\Downloads"
filewaschosen = fd.Show
fd.Execute
End Sub