Opening a recommended read only file as non read only

C

Crauwf

Hi, I'm struggling to create visual basic code to open a read-only file as
non read only so i can save down the changes.

When opening the file using the below code I am encountered with a pop up
message asking "s/s.xls should be opened as read only unless you need to save
changes to it. Open as read only?" and 3 options Yes, No, Cancel (of which
yes is the default option) How can I change it so that No is selected. Does
anyone know the correct code to do this?

Code to open workbook - Workbooks.Open Filename:= "s/s.xls"
 
J

Jim Rech

The Workbooks.Open method has an "IgnoreReadOnlyRecommended" parameter you
should set to True.

--
Jim
| Hi, I'm struggling to create visual basic code to open a read-only file as
| non read only so i can save down the changes.
|
| When opening the file using the below code I am encountered with a pop up
| message asking "s/s.xls should be opened as read only unless you need to
save
| changes to it. Open as read only?" and 3 options Yes, No, Cancel (of which
| yes is the default option) How can I change it so that No is selected.
Does
| anyone know the correct code to do this?
|
| Code to open workbook - Workbooks.Open Filename:= "s/s.xls"
 

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