Getting a Cell Value from another workbook

  • Thread starter Thread starter techmoney
  • Start date Start date
T

techmoney

Will you please help me

I'm having a hard time declaring a variable from a cell value, from
from another workbook.

Dim iMax As Integer

iMax = Cell.Value(workbook.["Plans.xls"].Sheet("Nov").Range("c1"))

Thanks in advance
 
Dim iMax As Integer

iMax = Workbooks("Plans.xls").Worksheets("Nov").Range("c1").Value


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorporating feature of second macro into first? 5
hide/unhide rows depending on the top input value 2
Macro to copy previous row and insert two blank rows 1
Cell values to an array, then array transpose to another workbook 8
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Copy Multiple Areas from One Workbook to Another 4
Arrays and scattered cell values or another way? 16
Scattered array cells copy to scattered array cells another workbook 14

Back
Top