Categories




create a Microsoft Access database

‘Add a reference to the Microsoft DAO 3.5 library

Private Sub Form_Load()
Dim ws As Workspace
Dim db As Database
Set ws = DBEngine.Workspaces(0)
Set db = ws.CreateDatabase(“test.mdb”, dbLangGeneral & “;pwd=Password”)
End Sub

Bookmark It

Hide Sites

$$(‘div.d81′).each( function(e) { e.visualEffect(’slide_up’,{duration:0.5}) });

Creates a file

Private Sub Form_Load()

Open “f:Test1.txt” For Output As #1
Write #1, “This is some sample text”
Write #1, “Programmershelp.co.uk”
Close #1

End Sub

Bookmark It

Hide Sites

$$(‘div.d80′).each( function(e) { e.visualEffect(’slide_up’,{duration:0.5}) });

create a text file

Private Sub Form_Load()

Dim objFSO As New FileSystemObject
Dim objFile As Object
Dim varString As Variant
varString = Array(“some”, “sample”, “text”)
Set objFSO = CreateObject(“Scripting.FileSystemobject”)
Set objFile = objFSO.CreateTextFile(“f:Test2.txt”)
objFile.WriteLine varString(0) & ” ” & varString(1) & ” ” & varString(2)
objFile.Close

End Sub

Bookmark It

Hide Sites

$$(‘div.d79′).each( function(e) { e.visualEffect(’slide_up’,{duration:0.5}) });

copy a text file

Private Sub Form_Load()

Dim objfso As New FileSystemObject
objfso.CopyFile “D:Test.txt”, “C:”

End Sub

Bookmark It

Hide Sites

$$(‘div.d78′).each( function(e) { e.visualEffect(’slide_up’,{duration:0.5}) });