Retrieve a value from a closed file

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Retrieve a value from a closed file

FAQ

Thread Tools

Display Modes

11-06-2018, 01:48 PM

macropod

Windows 7 64bit Retrieve a value from a closed file

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

An external reference formula contains the path, filename, sheet name and cell reference of the cell whose value you want to retrieve. Such a formula typically looks like:
='C:\Users\UserName\Documents\[SourceWorkbook.xlsx]Sheet1'!$A$1

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

active x, closed, reference

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Closed recovered file without saving - possible to retrieve?	username1234	Word	0	05-20-2018 04:54 AM
What Causes Outlook to Continue Changing File Size While Closed?	chasfh	Outlook	2	04-14-2018 06:32 AM
Retrieve old file version	Joven	Office	3	03-24-2018 11:21 PM
After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it	HGilbert	Excel	1	01-24-2017 08:37 AM
Importing Data from seperate closed excel file	KingoftheKassel	Excel Programming	1	06-10-2016 08:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.