I have the below code to bring information over from another spreadsheet, but every time I run the macro, I get a runtime error on the bold section. Can anyone please assist?
Private Sub CommandButton1_Click()
ChDir "C:\Test Sample Upload"
Workbooks.Open Filename:= _
"C:\Test...