Hi!
I'm trying to retrieve values of certain cells in certain worksheets of
certain workbooks. However, these Workbook files are often used by several
users and so I would like to just discreetly get the values in the
background, so hat it wouldn't interfere with the usage of other users. I've
tried Excel "far" referencing (e.g. 'D:\MainUser\[Bisets.xls]Tries'!$B$10)
and Application.ExecuteExcel4Macro function call. However, I got an error
400 out of that.
Other searches I've made all points to using Workbook.Open method (I guess
I'll really have to use this if there're no other options).
Can anyone give any suggestions? Thanks!
_________
Clifford