Home » Forums » Open Source Learning Center » Question and Answer

VBA Code to reference a cell from a closed workbook to a cell in another workbook

Submitted by rhouston08 on 15 November, 2011 - 21:20

I need vba code to reference a cell from a closed workbook to a cell in another workbook. I currently have code that is a combination of cells that create a file and path from where the file resides. So I'm trying to get what show's up as text, to appear as a formula so the true value can appear. How do I do this?

‹ VBA code driving me mad!!! Wants to understand this VBA code ›
»
Vishesh's picture

Take a look at this as

Submitted by Vishesh on 26 November, 2011 - 07:44.

Take a look at this as well

http://excelexperts.com/Get-Values-from-other-workbook-without-opening

»
Nick's picture

take a look at

Submitted by Nick on 21 November, 2011 - 21:00.

take a look at this:

http://excelexperts.com/Copying-cell-data-from-Workbook-A-to-Workbook-B

»