Thread: Open Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PEdro PEdro is offline
external usenet poster
 
Posts: 25
Default Open Workbook

Hi I have the following code:

If Workbooks("Analysis.xls").Worksheets("Names").Cell s(2, 3)="" Then
txtPass = InputBox("Please Insert Your Login")
Else
txtPass = Workbooks("Analysis.xls").Worksheets("Names").Cell s(2,
3).Value
End If


What code should I add in order that if the Workbooks("Analysis.xls") is not
opened continues the macro still runs txtPass = InputBox("Please Insert Your
Login") in the next line

Regards,
Pedro