worddoc attachment as icon in excel
We have old test cases written in excel and others not using QTP, but i want to create a script which will take the screenshots(multiple) from drive insert into excel against each test cases in excel,
I want the attachment as ICON aginst to each test case as per the orfer of attachment
like attach1 to the test case1 inthe excelsheet
i have created the following script, but its displaying as full screenshot
please take a look at the following script.
Set Xl = CreateObject("Excel.Application")
Set objWorkbook = Xl.Workbooks.Open(filepath)
docname = array("V1.Doc","V2.Doc","V3.Doc","V4.Doc")
for itr =0 to ubound(docname)
Set Ol = ReportSheet.OLEObjects.Add(,"C:\scripts\"&docname( itr), True)
.Left = ReportSheet.Range("A"&i).Left
.Height = ReportSheet.Range("A"&i).Height
.Width = ReportSheet.Range("A"&i).Width
.Top = ReportSheet.Range("A"&i).Top
What I normally do when I don't have any code relevant samples is record a macro whilst manually doing what I want then hack the recorded VBA.
My second step would then be to head over to somewhere like: CPearson.com Topic Index and see if there's anything here I could use.