View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Understanding this code snippett

Stuart,

Actually is stopping the execution of the code if either of the two files
"abc.exe" or "xyz.dll" are not present in the application directory path.

Brian

"Stuart" wrote in message
...
Thanks to you both.......looking for the file was my guess.
I assume that Application.Path MUST exist and be valid
since it must represent the host application (ie Excel or,
say Office) under which the sub is running.

Regards.

"Tom Ogilvy" wrote in message
...
if abc.exe or xyz.dll are missing from the application.path directory.

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
I have 'found' these lines:

If Len(Dir(Application.Path & "\" & "abc.exe")) = 0 _
Or Len(Dir(Application.Path & "\" & "xyz.dll")) _
= 0 Then
MsgBox " very long message "
Exit Sub
End If
Load UserForm1
UserForm1.Show
End Sub

What exactly is the If statement trying to determine,
please?

Regards.