217| 3
|
[经验求助] 【VBA或JS代码】EXCEL/WPS 根据姓名批量插入图片到指定单元格并自动匹配单元格 |
发表于 2024-4-27 15:51
30吾爱币
最佳答案https://wwi.lanzoup.com/iqlZV1wpn55c
[mw_shl_code=text,true]Sub InsertPicturesByNameAndResizeCell()
Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
Dim picturePath As String
Dim targetCell As Range
Dim picture As picture
Dim pictureWidth As Double
Dim pictureHeight As Double
' 设置工作表
Set ws = ThisWorkbook.Sheets("Sheet1")
...
| ||
发帖前要善用【论坛搜索】功能,那里可能会有你要找的答案或者已经有人发布过相同内容了,请勿重复发帖。 |
||
发表于 2024-4-27 15:51
| ||
发表于 2024-4-27 16:06
| ||
|
发表于 2024-4-27 16:11
| ||
RSS订阅|小黑屋|处罚记录|联系我们|吾爱破解 - LCG - LSG ( 京ICP备16042023号 | 京公网安备 11010502030087号 )
GMT+8, 2024-5-11 03:35
Powered by Discuz!
Copyright © 2001-2020, Tencent Cloud.