|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
发布配合【泡妞神器来啦,excel拼图!】使用的图片拆分源代码
http://club.excelhome.net/thread-1145437-1-1.html
注意
1.本工具需在excel2003版本下使用,其他版本切割出来的图片有问题
2.原图片大小建议用600x400,把图片切割为6x6
3.把每个小图片重新分配宏 sub picxx_click()
4.请有时间的朋友做个更加自动的工具
- Sub 拆分()
- Dim 原图 As Object
- Dim 多图 As Shape
-
- Dim i As Integer
- Dim j As Integer
- Dim num As Integer
- Dim myFname As String
-
- Dim 原图宽 As Single, 原图高 As Single
- Dim 拆分宽 As Single, 拆分高 As Single
-
- Const 间隙 As Integer = 5
- Dim 横拆分数 As Integer, 纵拆分数 As Integer
- myFname = Application.GetOpenFilename(FileFilter:="全部图片(*.jpg),*.jpg")
-
- If myFname = "False" Then Exit Sub
-
- Set 原图 = ActiveSheet.Pictures.Insert(myFname)
-
- With 原图
- .Top = 5
- .Left = 5
- End With
-
- 横拆分数 = Application.InputBox("横向要怎样拆分?", "请输入0以外的值")
- 纵拆分数 = Application.InputBox("纵向要怎样拆分?", "请输入0以外的值")
-
- 原图宽 = 原图.Width
- 原图高 = 原图.Height
- 拆分宽 = 原图宽 / 横拆分数
- 拆分高 = 原图高 / 纵拆分数
- 原图.Copy
- num = 1
-
- For i = 1 To 纵拆分数
- For j = 1 To 横拆分数
- ActiveSheet.Paste
- Selection.Name = "pic & num
- With ActiveSheet.Shapes("pic" & num)
- .Top = 间隙 * i
- .Left = 间隙 * j
- With .PictureFormat
- .CropTop = 拆分高 * (i - 1)
- .CropBottom = 拆分高 * (纵拆分数 - i)
- .CropLeft = 拆分宽 * (j - 1)
- .CropRight = 拆分宽 * (横拆分数 - j)
- End With
- End With
- num = num + 1
- Next
- Next
- 原图.Delete
-
- End Sub
复制代码
该贴已经同步到 xiamen168的微博 |
|