From the VB side, I'm trying to do a simple evaluation of two
different workbooks; specifically, certain cells in each workbook.
Ok, I CAN do it by setting a workbook to be 'active' and then getting
my data, switching the other to active, then doing the same. I can
even hide it by turning off application updating.
But WHY can't I do...
MyVariable = Workbook("TestBook1.xls").sheets("Sheet1").cells("b1") ?
Is it simply an issue of I can go that many layers deep? Would doing a
With statement work? ARGHH! Dunno WHY this simple issue is driving
me up a wall. but any thoughts would be helpful. :)