WoundEdGoat
Programmer
I would like to know how to set up my program to load data into the program in the event that a user double-clicks on a related data file or drags a file onto the program.
Thanks.
Thanks.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Private Sub picContactPortait_OLEDragOver(Data As DataObject, Effect As Long, Button As Integer, Shift As Integer, x As Single, y As Single, State As Integer)
Dim vFN As Variant
Dim sFirstFileName As String
Dim sExt As String
If Data.GetFormat(vbCFFiles) Then
sFirstFileName = Data.Files.Item(1)
sExt = Right(sFirstFileName, Len(sFirstFileName) - InStrRev(sFirstFileName, "."))
sExt = UCase(sExt)
If sExt = "BMP" Or sExt = "GIF" Or sExt = "JPG" Or sExt = "JPEG" Then
Select Case State
Case Is = vbEnter
Set picOld.Picture = picContactPortait.Picture
Set picContactPortait.Picture = LoadPicture(sFirstFileName)
Effect = vbDropEffectCopy
Case Is = vbOver
Effect = vbDropEffectCopy
Case Is = vbLeave
Set picContactPortait.Picture = picOld.Picture
Set picOld.Picture = Nothing
Effect = vbDropEffectNone
End Select
Else
Effect = vbDropEffectNone
End If
End If
End Sub
Private Sub picContactPortait_OLEDragDrop(Data As DataObject, Effect As Long, Button As Integer, Shift As Integer, x As Single, y As Single)
Dim vFN As Variant
Dim sFirstFileName As String
Dim sExt As String
If Data.GetFormat(vbCFFiles) Then
sFirstFileName = Data.Files.Item(1)
sExt = Right(sFirstFileName, Len(sFirstFileName) - InStrRev(sFirstFileName, "."))
sExt = UCase(sExt)
If sExt = "BMP" Or sExt = "GIF" Or sExt = "JPG" Or sExt = "JPEG" Then
Set picContactPortait.Picture = LoadPicture(sFirstFileName)
Else
Effect = vbDropEffectNone
End If
End If
End Sub