I got this code from the website:

Sub test()
GetValuesFromAClosedWorkbook "C:", "Book1.xls", "Sheet1", "A1:A30"
End Sub

Sub GetValuesFromAClosedWorkbook(fPath As String, fName As String, _
sName, cellRange As String)

With ActiveSheet.Range(cellRange)
..FormulaArray = "='" & fPath & "\[" & fName & "]" & sName &
"'!" & _ cellRange
..Value = .Value
End With
End Sub

Can someone explain how it works? It looks like the path/file name is
already configured, so why (when I run the code) does an "Update
Records" dialog box pop up?


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=559565