|
说明:1.点击附件中“保存窗体图片”按钮出现窗体
2.窗体上有3个控件:文本框PN,图片image1,命令按钮cmdSave
要求:如何在点窗体上“保存图片”按钮时把图片按文件名为PN(就是文本框的名称,可以随意输入内容) 保存到同目录下的“产品图片”文件夹中 ???
- Private Sub cmdSave_Click()
- Dim strPath$, strFilename$
-
- If Len(Me.PN.Text) = 0 Then
- MsgBox "PN为空"
- Exit Sub
- End If
-
- If Me.Image1.Picture Is Nothing Then
- MsgBox "图形控件中无加载图形"
- Exit Sub
- End If
-
-
- On Error Resume Next
-
- strPath = ThisWorkbook.Path & Application.PathSeparator & "产品图片" & Application.PathSeparator
- strFilename = Me.PN.Text & ".bmp"
- MkDir strPath
-
- If Len(Dir(strPath & strFilename)) Then
- If MsgBox(prompt:=" 当前 产品图片 下已经存在 " & strFilename, Buttons:=vbYesNo + vbInformation, Title:="是否覆盖文件") = vbNo Then
- Me.PN.SetFocus
- Exit Sub
- End If
- End If
-
- On Error GoTo ErrorHandler
-
- SavePicture Me.Image1.Picture, strPath & Me.PN.Text & ".bmp"
- MsgBox "导出完成"
- Exit Sub
-
- ErrorHandler:
- MsgBox Err.Number & vbNewLine & Err.Description
- End Sub
复制代码
|
|