get info from another excel file without opening it

I can't quite figure this out.
I want to run a macro the will:
-display an open dialog box for xlsm files only
-test if a value is TRUE in cell A1 of the chosen file without actually opening the file.
Can this be done? Can I retrieve numerical values without opening as well?

This link perhaps?

http://spreadsheetpage.com/index.php...a_closed_file/

Alf

Thanks for the replies guys. I have seen many examples to do this but they all need user defined file paths (unless I'm overlooking something-new to VBA). I want the user to be able to choose what file, no matter the location and get/read data from a closed workbook without opening.

This is what I have so far. New at VBA so there may be mistakes. Haven't tested:

Private Sub AddWAA()
Dim strFileToOpen As String
Dim PromptCause As String
Dim bError As Boolean

bError = True
'Use open prompt to choose a file to import data
strFileToOpen = Application.GetOpenFilename _
(Title:="Please select an WAA file to merge", _
FileFilter:="Excel Files *.xlsm (*.xlsm),")
'Checking if file is selected
If strFileToOpen = False Then
Exit Sub
End If
'Check named range data in closed WB without opening
If Range("WAAFile") = False Then
PromptCause = "The file you selected is not a WAA file."
bError = False
ElseIf Range("ReportGen") = False Then
PromptCause = "The WAA file you selected has not generated a report yet."
bError = False
End If
If bError = False Then
MsgBox PromptCause, vbOKOnly, "WAA: Merge Error"
Exit Sub
End If
'Transfer data from named range in closed WB and transfer to active WB
Range("ClosedWAAFile") = Range("OpenWAAFile")
MsgBox "Success", vbOKOnly, "Data merge"
End Sub