'Path not found - GetOpenFilename VBA Error
I'm trying to build a sub that allows a user to attach an image to a user form, my approach is to use OpenFileName to get the file path of the chosen, and then copy it into another folder for that submission for later use. I keep on getting a path not found error each time I select an image. It gets thrown as soon as GetOpenFilename is executed. Why is this happening and is there a better way that I could be going a bout this? Thanks.
Private Sub AttachImagesButton_Click()
Dim photoPath As Variant
Dim newTicketFolderName, destination As String
'get user to select a photo from disk and assign to
photoPath = Application.GetOpenFilename("Image Files (*.*), *.*", , "Select image")
On Error GoTo Error
If photoPath = False Then Exit Sub
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
