How to reference a cell from anther workbook without opening it

7

7055

Joined
May 6, 2015
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save As and new workbook new name used in existing code 8
values from workbook without opening it 5
VBA code for pasting links -- modifying RDB code for summary workbook 10
Cell values to an array, then array transpose to another workbook 8
Import multiple workbooks to current workbook in specified row number 0
Select range from unopened workbook 7
Open four Wbooks, copy four columns from each to Master Wbook 16
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top