Difference between revisions of "File System + File I/O in VB6"

From Free Knowledge Base- The DUCK Project: information for everyone
Jump to: navigation, search
m (Other File System Methods)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
<big>*must add '[[References, Components, and Controls List VB6|reference]]' to "Microsoft Scripting Runtime"</big>
+
== Microsoft Scripting Runtime / FSO  ==
  
 +
<big>*must add '[[References, Components, and Controls List VB6|reference]]' to "Microsoft Scripting Runtime"</big>
 
* Be sure to "Set fso = Nothing" unless you like memory leaks and virtual memory errors in Windows.
 
* Be sure to "Set fso = Nothing" unless you like memory leaks and virtual memory errors in Windows.
  
== Write/Create a new file using FileSystemObject ==
+
=== Write/Create a new file using FileSystemObject ===
  
 
   Dim fso As New FileSystemObject, fsoStream As TextStream
 
   Dim fso As New FileSystemObject, fsoStream As TextStream
Line 17: Line 18:
 
&nbsp;
 
&nbsp;
  
== Check if File Exists ==
+
=== Check if File Exists ===
  
 
  Private Function LocalFileExists() As Boolean
 
  Private Function LocalFileExists() As Boolean
Line 30: Line 31:
 
&nbsp;
 
&nbsp;
  
== Delete File ==
+
=== Delete File ===
  
 
  strDst = strLCRMpath & "\" & Trim("" & strRemoteFileName)
 
  strDst = strLCRMpath & "\" & Trim("" & strRemoteFileName)
Line 37: Line 38:
 
&nbsp;
 
&nbsp;
  
== Copy File (Backup File) ==
+
=== Copy File (Backup File) ===
  
 
  fso.CopyFile strFileSpec, Replace(strFileSpec, ".xml", ".bak")
 
  fso.CopyFile strFileSpec, Replace(strFileSpec, ".xml", ".bak")
Line 50: Line 51:
 
&nbsp;
 
&nbsp;
  
== Write if exists, create if doesn't exist using FileSystemObject ==
+
=== Write if exists, create if doesn't exist using FileSystemObject ===
  
 
   If fso.FileExists(strFileSpec) Then
 
   If fso.FileExists(strFileSpec) Then
Line 66: Line 67:
 
&nbsp;
 
&nbsp;
  
== Launch Another Program (any) From Your VB Program ==
+
== Other File System Methods ==
 +
 
 +
=== Launch Another Program (any) From Your VB Program ===
  
 
  Private Sub launchSLXAssist()
 
  Private Sub launchSLXAssist()
Line 76: Line 79:
 
   End If
 
   End If
 
  End Sub
 
  End Sub
 +
 +
The above includes an optional command line parameter.  The program being launched, in this example, checks for that command line parameter.  It uses the reserved constant "Command".
 +
 +
Private Function CheckLauncherParamter()
 +
  If InStr(LCase(Command), "/verified") > 0 Then
 +
    CheckLauncherParamter = True
 +
    blnDebug = False
 +
    mnuFileExit.Enabled = False
 +
  ElseIf InStr(LCase(Command), "/debug") > 0 Then
 +
    CheckLauncherParamter = True
 +
    blnDebug = True
 +
    mnuFileExit.Enabled = True
 +
  Else
 +
    CheckLauncherParamter = False
 +
  End If
 +
End Function
  
 
&nbsp;
 
&nbsp;
  
== Check if Network Path and File are available ==
+
=== Check if Network Path and File are available ===
  
 
  Private Sub checkFile01()
 
  Private Sub checkFile01()
Line 103: Line 122:
 
  End Sub
 
  End Sub
  
 +
 +
&nbsp;
  
 
&nbsp;
 
&nbsp;

Latest revision as of 15:59, 7 February 2008

Microsoft Scripting Runtime / FSO

*must add 'reference' to "Microsoft Scripting Runtime"

  • Be sure to "Set fso = Nothing" unless you like memory leaks and virtual memory errors in Windows.

Write/Create a new file using FileSystemObject

 Dim fso As New FileSystemObject, fsoStream As TextStream
 Dim rec1, strLine, strFileSpec
 Dim cnt0 As Integer, tag1 As Integer
 strFileSpec = Environ("HOMEPATH") & "\My Documents\kaching.log"
 strLine = "kaching incident " & Date & " " & Format(time, "HH:mm:ss") & vbCrLf
 Set fsoStream = fso.CreateTextFile(strFileSpec, True)
 fsoStream.Write strLine
 fsoStream.Close
 Set fsoStream = Nothing: Set fso = Nothing

 

Check if File Exists

Private Function LocalFileExists() As Boolean
  Dim fso As New FileSystemObject
  Dim strSrc As String, strDst As String
  strSrc = Trim("" & strRemoteFileName)
  strDst = strLCRMpath & "\" & Trim("" & strRemoteFileName)
  If fso.FileExists(strDst) Then LocalFileExists = True Else LocalFileExists = False
  Set fso = Nothing
End Function

 

Delete File

strDst = strLCRMpath & "\" & Trim("" & strRemoteFileName)
fso.DeleteFile strDst

 

Copy File (Backup File)

fso.CopyFile strFileSpec, Replace(strFileSpec, ".xml", ".bak")

With error handling:

On Error GoTo SkipBackup
  If blnNoWriteFileInDebug <> True Then fso.CopyFile strFileSpec, Replace(strFileSpec, ".xml", ".bak")
SkipBackup:
On Error GoTo 0

 

Write if exists, create if doesn't exist using FileSystemObject

 If fso.FileExists(strFileSpec) Then
   Set fsoStream = fso.OpenTextFile(strFileSpec, 2)
 Else
   Set fsoStream = fso.CreateTextFile(strFileSpec, True)
 End If
 
 fsoStream.Write strLine
 fsoStream.Close
 Set fsoStream = Nothing: Set fso = Nothing
 ' strFileSpec, 1 : ForReading 2 : ForWriting  8 : ForAppending  

 

Other File System Methods

Launch Another Program (any) From Your VB Program

Private Sub launchSLXAssist()
  Dim intExecute%
  If InStr(LCase(Command), "/interpreter") > 0 Then
    MsgBox "Shell SLXAssist.exe"
  Else
    intExecute% = Shell("SLXAssist.exe /verified", 1)
  End If
End Sub

The above includes an optional command line parameter. The program being launched, in this example, checks for that command line parameter. It uses the reserved constant "Command".

Private Function CheckLauncherParamter()
  If InStr(LCase(Command), "/verified") > 0 Then
    CheckLauncherParamter = True
    blnDebug = False
    mnuFileExit.Enabled = False
  ElseIf InStr(LCase(Command), "/debug") > 0 Then
    CheckLauncherParamter = True
    blnDebug = True
    mnuFileExit.Enabled = True
  Else
    CheckLauncherParamter = False
  End If
End Function

 

Check if Network Path and File are available

Private Sub checkFile01()
'   [step 1]: check to see if the network path and autoupdate.xml are available
  Dim fLen As Integer
  Dim strResponse%
  tmr.Enabled = False
  intbarProg = 0: barProg.Value = intbarProg

  On Error Resume Next
  fLen = Len(Dir$(xmlfilepath))
  strResponse% = vbRetry
  While strResponse% = vbRetry
    If Err Or fLen = 0 Then
    ' file dosent exist
      strResponse% = MsgBox("Error: XML inaccessible for auto-update!", vbAbortRetryIgnore, "SALESLOGIX ASSISTANT")
    Else
    ' file exists
      strResponse% = 0
    End If
  Wend
  On Error GoTo 0
End Sub