Workbooks.Open (... problem

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.



Answer this question

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


  • Workbooks.Open (... problem