Solved

visual basic 6 determine if computer is on network

Posted on 2009-04-03
2
216 Views
Last Modified: 2012-05-06
I want to determine if a computer is running using vb 6.0. I am implementing a fail-over system and wanted something that returns the information quickly
0
Comment
Question by:adimit
2 Comments
 
LVL 10

Expert Comment

by:c0ldfyr3
ID: 24066741
Here´s a very quick and dirty way to do with vbscript. You can´t do itwith VB as the application will fail to load if the redistributablesaren´t installed!

Option Explicit
 
Const SYSTEM32 = &H25&
 
Dim objShell, objFolder, objFolderItem, objFSO, sPath, sFile
 
Set objShell = CreateObject("Shell.Application")
Set objFSO =  CreateObject("Scripting.FileSystemObject")
Set objFolder = objShell.Namespace(SYSTEM32)
Set objFolderItem = objFolder.Self
 
sPath = objFolderItem.Path
 
If Right(sPath,1) <> "\" Then sPath = sPath & "\"
 
sFile = sPath & "Msvbvm60.dll"
If objFSO.FileExists( sFile ) Then
    Wscript.Echo "VB6 Installed"
End If
 
sFile = sPath & "Msvbvm50.dll"
If objFSO.FileExists( sFile ) Then
    Wscript.Echo "VB5 Installed"
End If

Open in new window

0
 
LVL 10

Accepted Solution

by:
Chad Smith earned 500 total points
ID: 24093798
Check if a network file exists

Function FileExist(sTestFile As String) As Boolean
   'This function does not use DIR since it is possible that you might have
   'been in the middle of running DIR against another directory in
   'an attempt to match one directory against another.

   'It does not handle wildcard characters
   Dim lSize As Long
   On Error Resume Next
   'Preset length to -1 because files can be zero bytes in length
   lSize = -1
   'Get the length of the file
   lSize = FileLen(sTestFile)
   If lSize > -1 Then
      FileExist = True
   Else
      FileExist = False
   End If
End Function
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now