Opening a ReadOnly file in Excel VBA
hmmm i never knew that - it works ok with other functions.
i have been programming in VBA for years and just picked
up stuff along the way - i suppose that is the trouble
with self-teaching ;op
thanks
-----Original Message-----
syntax rules say you don't enclose arguments in
parentheses unless you use
the Call statement or you are calling a function and it
is returning a
value. Since you are not doing that, you shouldn't use
parentheses around
your arguments.
--
Regards,
Tom Ogilvy
"Demon" wrote in message
...
excellent that worked - strange that my version did not
work considering it was the same args but a different
format! i shall remember that!
thanks v.much :o)
-----Original Message-----
Try this:
Application.Workbooks.Open _
Filename:=JobListPath,
IgnoreReadOnlyRecommended:=True
Shunt
.
.
|