View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Demon Demon is offline
external usenet poster
 
Posts: 2
Default 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
.



.