Assign a cell value (from another file) to a varieble
 

I have try too many things but it does not work.... need to pick up a value
from a cell and place it into a variable... I tried

myVal.Value = [FM Deviation Request R1.0.xls].Form.R2C17
myVal = AOS Deviation Request R1.0.xls.Sheets("AOS Form").Range("Q2").Value"
and many more but can not work.

Assign a cell value (from another file) to a varieble
 

Dim myVal as Variant
Dim wb as Workbook

'For referring Open workbook
Set wb = Workbooks("workbookname.xls")

'To open a excel file and reference it
'Set wbBook = Workbooks.Open("<fullpath\<filename.ext")

myVal = wb.Sheets("Sheet1").Range("Q2").Value
Msgbox myVal

If this post helps click Yes
---------------
Jacob Skaria


"Alberto Ast" wrote:

I have try too many things but it does not work.... need to pick up a value
from a cell and place it into a variable... I tried

myVal.Value = [FM Deviation Request R1.0.xls].Form.R2C17
myVal = AOS Deviation Request R1.0.xls.Sheets("AOS Form").Range("Q2").Value"
and many more but can not work.

Assign a cell value (from another file) to a varieble
 

myVal = workbooks("AOS Deviation Request R1.0.xls").WorkSheets("AOS
Form").Range("Q2").Value

Tim



"Alberto Ast" wrote in message
...
I have try too many things but it does not work.... need to pick up a value
from a cell and place it into a variable... I tried

myVal.Value = [FM Deviation Request R1.0.xls].Form.R2C17
myVal = AOS Deviation Request R1.0.xls.Sheets("AOS
Form").Range("Q2").Value"
and many more but can not work.