View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Workbook.Open Question

I've been having some intermittent failures in a macro I'm running. I just
realized that I had

Set oWB = Workbooks.Open(sFile)

Instead of

Set oWB = Workbooks.Open(sFile, UpdateLinks = False, ReadOnly = True)

Could that be causing my problem if someone else is using the file?

Thanks,
Barb Reinhardt