Sorry about the syntax issue. (I moved it from a normal variable inside
the procedure to a global constant at the top of the module, but forgot
to change the syntax. The declare should read...

Const sXLFileToOpen As String ...

instead of...

Const sXLFileToOpen$

...as type symbols are not allowed in constant declares or Type
structures. My bad!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion