how to refer to a non active workbook in VBA???

[Mav93]

Hi everyone !!!!!
is there a way to refer to a non active workbook
I know this code isn't correct but may you can get the idea

Active workbook("Olson Bros Bid Information Sheet.xls").sheets("data").range("A1").value = NonActive workbook("take off forms")Sheets("cost sheet").range("A1")


please let me know if I'm way off I'm still pretty new to VBA
thanks for the help!!!!

 

[Norie]

Just change Workbook to Workbooks.

Workbooks("Olson Bros Bid Information Sheet.xls").sheets("data").range("A1").Value = Workbooks("take off forms")Sheets("cost sheet").range("A1")

 

[HalfAce]

Hello Mav93
There are a couple ways to do that. Norie has pointed out the most common
and (in my opinion) the best.
To do it using ActiveWorkbook though you could use this.

ActiveWorkbook.Sheets("data").Range("A1").Value = _
  Workbooks("take off forms").Sheets("cost sheet").Range("A1").Value

 

[Mav93]

Thanks half ace and norie actually I ended up using both of the codes that you provided.


Thanks again