VBA: Referencing a cell from a workbook into a module

[mkingrey]

I have a module and a workbook and need to refenerence a cell from WorkBookA in the VBA of Module1. I searched for a solution on the message board but can't find a similar question.

I need something like this:

Sub RunReport()

'This code resides in Module1 
Dim ReportDate As String

ReportDate = WorkBookA!K2.Value


End Sub

 

[sykes]

Is the module in the same project as the workbook?

If so just refer directly to the sheetname containing the cell in question:

Sub RunReport()

'This code resides in Module1
Dim ReportDate As String

ReportDate = sheets("sheet1").range("K2").Value

' ........and to test if it's working

msgbox ReportDate

End Sub

Just change the "Sheet1" ref to the name of your worksheet containing K2.

 

[Andrew Poulsom]

Workbook?

ReportDate = Workbooks("WorkBookA.xls").Worksheets("Sheet1").Range("K2").Value

or Worksheet?

ReportDate = Worksheets("WorkBookA").Range("K2").Value

 

[mkingrey]

Yes I did mean "worksheet"

It worked. Thanks for the help!!!