Bypass "Read Only" Dialog

First, let me say this is a great site! Wish I had found it years ago.

I have written a macro that works great, trying to streamline user interface and have run across two things. Have tried searching for answers here but came up with nothing.

1. Getting info from a file that is password protected, when it is opened you have the choice to enter a password to enable editing or open as read only. For the purpose of the macro I need/want/must have read only. How do I do this? Here is the code I use to open the workbook.


Workbooks.Open Filename:="\\myPath\Master ID List.xls"


2. When I close the above mentioned file, I get prompted with another dialog box saying "There is large amount of information on the clipboard..." and it is defaulted to "Yes". Is it posible to change the default to "No"? I don't see this dialog with "DisplayAlerts = False", but it does slow down the macro and I don't need to save the info.

Thanks in advance for any responses.

ww

#1) Would this work (not tested):

Please Login or Register  to view this content.

#2) Try this before your Close Event

Please Login or Register  to view this content.

Hope this helps you out!