Hello everyone, Just need help with a macro. what I need is a macro to prompt agent to select .csv file then to copy data from range B2:H300 of the selected .csv and paste value to cell c5 of the excel. I was able to come up with file dialog is as far as i got.
any help is greatly apprecated
VBA Code:
Sub PullCSVData()
With application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.Filters.Add "Excel Files", "*.csv", 1
.Show
fullpath = .SelectedItems.item(1)
End With
End Sub
any help is greatly apprecated