Hi all,
As I understand, the code to reference data from a cell that is in a different workbook is as follows:
Workbooks("InvoiceData.xlsx").Worksheets("Sheet1").Range("A1")
So why then, if I use the following code, and assuming the file path is correct, does the following not work for me?
Range("b2") = Workbooks("\\USN001\P311941_us_ah\PART_C_Project_Documentation\C10_Test_Results\Durability_Testing\313_BJ_EV\MRDA_VEHICLE_313_DAILY_LOG_MASTER.xls").Worksheets("lap and charge times").Range("D24")
Thank you
As I understand, the code to reference data from a cell that is in a different workbook is as follows:
Workbooks("InvoiceData.xlsx").Worksheets("Sheet1").Range("A1")
So why then, if I use the following code, and assuming the file path is correct, does the following not work for me?
Range("b2") = Workbooks("\\USN001\P311941_us_ah\PART_C_Project_Documentation\C10_Test_Results\Durability_Testing\313_BJ_EV\MRDA_VEHICLE_313_DAILY_LOG_MASTER.xls").Worksheets("lap and charge times").Range("D24")
Thank you