VB and Option Explicit

[Russ]

Trying to run a macro to export hierarchy to Excel. I
keep getting a VB error saying that Option Explicit is a
syntax error. I seem to remember running into this
before, but never resolved the issue. Anyone else run
into this?

Thanks

Russ

 

[JackD]

Are you by any chance running a macro which was downloaded from my site
(http://masasmiki.com/project)?
If so the problem is not in the option explicit line, it is in the line
beginning with attribute.

Comment that out using an apostrophe ' and it will run fine.

-Jack

 

[Mark Durrenberger]

fyi "Option explicit" tells the VB complier that all variables must be
declared before use (explicit declaration) - it is an enourmous help to
those of us who write code because it virtually eliminates variable name
typos like

dim blnOpen as boolean

bln0pen = True ' this will puke the compliler if "option explicit"

Mark

--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones