Reference Range("").value in another workbook [Resolved]
Alright, I have done this a billion times before but for some reason I cannot figure out what is going wrong.
I am not able to grab the value from a cell using the workbook name, sheet name and cell address like below:
Code:
MsgBox Workbooks("book1").Sheets("Sheet1").Range("$A$1").Value
Can someone please point out my moronic mistake?
Re: Reference Range("").value in another workbook
Code:
MsgBox Workbooks("book1.xls").Sheets("Sheet1").Range("$A$1").Value
God, what an idiot.
Yeah, .xls
Ever had one of those days?