find data another workbook

[Guest]

Hi

Thanks in advance Don't know to reference another workbook with folder and
file name.

Looking at the following code I am unsure how to get information from other
spreadsheets.

In the loop the folder will look at various stores. The following shows
perth but does not look at it. I have 10 other stores to look at.

How do I reference another workwook.


Dim strLookSheet As String
Dim varAnswer As Variant
Dim strWorkbookFolder As String
Dim strWorkbookFile As String

strWorkbookSheet = "Meats"
strWorkbookFolder = "C:\data\perthstore\"
strWorkbookFile = "Today_Sales"

varAnswer = Worksheets(strWorkbookSheet).Range("D6").Value





thanks for all your help.

Trev B

 

[Guest]

strWorkbookSheet = "Meats"
strWorkbookFolder = "C:\data\perthstore\"
strWorkbookFile = "Today_Sales"

Workbooks.Open Filename:= _
strWorkbookFolder & strWorkbookFile

Windows(strWorkbookFile).Activate
varAnswer = Worksheets(strWorkbookSheet).Range("D6").Value