Getting cell value from unopened file

  • Thread starter Thread starter Hardy
  • Start date Start date
H

Hardy

In VBA, I am trying to assign value to variable that is cell value of A
in file that is not open (this value is a date).

It is easy to create links within a worksheet to other un-opened files
so must be way of doing similar within VBA.

I have searched around on this without success, so any quick pointer
greatly appreciated
 

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

Select range from unopened workbook 7
Import Cell Values From An Unopen XLS File 3
Copy value from changing cells without VBA 1
Help with Grabbing Cell Value from Range 4
How to access VBA variable from active worksheet 1
Search and Collect Date from Cell Containing a String with a Date 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Assign multiple cell's values to a variable 2

Back
Top