A
ANtonis
I am new to visual basic and I guess that what I am
asking can be a very easy thing to do but not for me.
I am trying to get the value of the cell of a closed
workbook2.xls inside an activated workbook1. But I cannot
do that unless workbook2 is also running (inactivated).
I want to get this value though without having to open
workbook2. If thats impossible can I open workbook2 just
by typing some code inside workbook1?
The command I am using at the moment is
Range("A1").Value = Workbooks("WorkBook2.xls").Worksheets
("Sheet1").Range("A1").Value
I would really appreciate any ideas you offer me thank
you very much...
asking can be a very easy thing to do but not for me.
I am trying to get the value of the cell of a closed
workbook2.xls inside an activated workbook1. But I cannot
do that unless workbook2 is also running (inactivated).
I want to get this value though without having to open
workbook2. If thats impossible can I open workbook2 just
by typing some code inside workbook1?
The command I am using at the moment is
Range("A1").Value = Workbooks("WorkBook2.xls").Worksheets
("Sheet1").Range("A1").Value
I would really appreciate any ideas you offer me thank
you very much...