I get a this error "Runtime error 1004: application defined error or object defined error"
My code
Any ideas of what the problem is?
My code
VBA Code:
Sub Import_Data()
Dim src As Workbook
Dim dest As Workbook
'Dim rng As Range
Set src = Workbooks.Open([A3])
Set dest = Workbooks.Open("T:\Datawarehouse_FOCUSToronto\Source\Source.xlsx")
'rng = Workbooks("Discussion Notes - BC 2022.xlsm").Worksheets("Sheet1").Cells(17, 2).Value
'Copy range to clipboard
Workbooks("Discussion Notes - BC 2022.xlsm").Worksheets("Data Fields").Range(Cells(17, 2).Value).Copy
'PasteSpecial to paste values, formulas, formats, etc.
Workbooks("Source.xlsm").Worksheets("Sheet1").Range("B2").PasteSpecial Paste:=xlPasteValues
End Sub
Any ideas of what the problem is?