Good morning archiboy

Try this:

Workbooks.Open Filename:="C:\Test.xls", ReadOnly:=True

HTH

DominicB

"archiboy" wrote:

can anyone please help me on this?

how can I use the open.workbook function to open a workbook as read-only or
specifically write-enabled.

any help would be greatly appreciated
thanks