macro to open file in read only

  • Thread starter Thread starter Dennis Schuessler
  • Start date Start date
D

Dennis Schuessler

Can you create a macro to open other workbooks in read
only mode. This way even is the file is being modifed by
someone else it will allways open with the macro?
 
Hi
try something along the lines of:

Workbooks.Open filename:="c:\temp\book.XLS", radonly:=True
 
You must log in or register to reply here.

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

Similar Threads

Read Only 3
macro-import another xls file 15
Tracking Access in Read-Only Files 0
Run Macro Automatically When Excel 2003 Opens 2
Macro Read Only If Statement 1
How to run a macro automatically when the file is opened? 1
Macro to open seperate workbook 3
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Back
Top