View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Brenner John Brenner is offline
external usenet poster
 
Posts: 9
Default Opening Workbook as Read Only and using ".Activate"

I have code that opens the file and activates it:

Workbooks.Open(FileDir & FilesInPath).Activate

But I want to combine this with arguments that will open the file as read
only:

Workbooks.Open(FileDir & FilesInPath).Activate , ReadOnly:=True, _
Password:="Metrics"

This line gives me an error "invalid number of arguments".

Is it possible to open as active as read-only?

Thanks -
--
Regards,
John