Open files Read-only with VBA

S

SortOfNotQuite

I can record a macro while I open files in Read-only mode, but the code does
not reflect that the files were opened "read-only".

When I try to use the code, it does not do what I want. I tried using
"FileOpen Name:= <>\file.published" ,ReadOnly and several variations of that.
No worky.

Simple error?
 
S

SortOfNotQuite

I figured it out. The F1 help was confusing me with the ( and [. For anybody
looking for the answer it is:
FileOpen "<>\Project.Published", ReadOnly:=True
 
G

Guidho

In EPM 2003, you need to use:
FileOpen Name:="<>\filename.published", ReadOnly:=True

In EPM 2007, you need to use
FileOpen Name:="<>\filename", ReadOnly:=True

Regards,
Guidho
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top