Get values from a closed workbook

[kev_06]

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?

 

[halim]

Dear KEV06,

Let me try to explain you that :
(the explanation is after " '-->" and " _" mark & ended by dot.)

Sub test()
GetValuesFromAClosedWorkbook "C:", "Book1.xls", "Sheet1", "A1:A30"
' --> call _
GetValuesFromAClosedWorkbook sub event to raised up the event.
End Sub

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

With ActiveSheet.Range(cellRange)
.FormulaArray = "='" & fPath & "\[" & fName & "]" & sName &
"'!" & cellRange ' --> excel _
standard way of linked cells to another Workbook that
currently not open.
.Value = .Value ' --> return formularray to value.
End With
End Sub


Or you can contact me directly to (e-mail address removed)
thats all,

halim



kev_06 menuliskan:

 

[Ron de Bruin]

See
http://www.rondebruin.nl/copy7.htm