Hi all,
I am trying to open a workbook in readonly mode. I have tried Workbooks.Open(WorkFN, 2, True) but this is asking to assign the result to a variable. i.e. it won't compile without an "=" sign.
What am I doing wrong I just want to open the file, copy some stuff out of it, and then close it again. Fell at the first hurdle!
Cheers,
Steve.

Workbooks.Open (... problem
Vinodonly
Hi
Just lose your brackets and all should be well i.e.
Workbooks.Open WorkFn, 2, True
Christopher New
Brilliant - thanks!
Steve