capturebitmap and save image in .xls cell

上一篇 / 下一篇  2008-06-03 13:59:32 / 个人分类:QTP脚本

Set ōExcel = CreateObject("Excel.Application")
On Error Resume Next
oExcel.WorkBooks.
Open "C:\YourFile.xls"
Set ōbjSheet = oExcel.ActiveWorkbook.Worksheets(1)
objSheet.OLEObjects.Add(,
"C:\YourImageFile.png",False,True, "mspaint.exe",0,"C:\YourImageFile.png").Select
oExcel.ActiveWorkbook.Save : oExcel.ActiveWorkbook.
Close
oExcel.Application.Quit
Set ōExcel = Nothing : Set ōbjSheet = Nothing

Would this help any

Sub InsertAndMovePicture(sPictureName As String, sCellAddress As String)

With ActiveSheet.Pictures(sPictureName)
    .Left = ActiveSheet.Range(sCellAddress).Left
    .Top = ActiveSheet.Range(sCellAddress).Top
  End With
End Sub
Sub CallMovePicture()
ActiveSheet.Pictures.Insert("C:\CRISNET\EXPORT\CMA_Picture_Group\CMA_Picture.jpg").Select
    Selection.Name = "Picture-1"
    Application.Run "InsertAndMovePicture", "Picture-1", "A1"
End Sub


TAG: QTP脚本

 

评分:0

我来说两句

我的栏目

日历

« 2024-04-24  
 123456
78910111213
14151617181920
21222324252627
282930    

数据统计

  • 访问量: 2095
  • 日志数: 3
  • 建立时间: 2008-04-25
  • 更新时间: 2008-06-03

RSS订阅

Open Toolbar