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
Gerald Hopkins211244
Hi
Just lose your brackets and all should be well i.e.
Workbooks.Open WorkFn, 2, True
CraigT
Brilliant - thanks!
Steve