saranyavijayan

• Aug 8th, 2006

 

This function is for getting datatable(excel sheet) in test director.

try to use it and as vbs file and call this function to get ur datatable.

GetAttachment(FileName, OutPath)

FileName	The name of the attachment that needs to be copied
OutPath	The folder location where the file needs to be stored
Return value	The full path where the file has been copied on the local file system

Example:
FilePath = GetAttachment("test.pdf", "C:")
MsgBox "Your file is here:" & FilePath

The GetAttachmentFromTest finds the attachment associated to the given test name and stores it in a local folder.

GetAttachmentFromTest(TestName, FileName, OutPath)

TestName	The name of the test where the attachment is located
FileName	The name of the attachment that need to be copied
OutPath	The folder location where the file needs to be stored
Return value	The full path where the file has been copied on the local file system

Example:
FilePath = GetAttachmentFromTest("Attachment", "hello.vbs", "C:aa")
MsgBox "Your file is here:" & FilePath

try using this..let me no if any issues

gosimang45

 Profile Answers by gosimang45 

• Aug 16th, 2006

 

i need to know in detail how to export excel sheet to TD using vbs,does one have to go to Tools--->macros---->vb editor, from the excel menu? If yes what code do u put in the editor,please give an example.Thanx

Raghu Ram

• Aug 17th, 2006

 

 We can directly attach any file to req.module or for defect module using add attachment option.if u want any clarification mail me: tamminas_ramu@yahoo.co.in

mahi

• Sep 26th, 2006

 

word and excel Addins available in QC first we should install those addins in our local m/c. Then we can easily export to QC.

sudhakar2068

 Profile 

• Nov 3rd, 2006

 

The Test attachment is optional part in Test directory. Test engineers are using this concept to attach any extract Supported file for Testing.

Ex:Excel sheet with Test date, Flat file with Test date. Etc.

sudhakar kolla,

My email:kollasudhakar2005@yahoo.co.in.

My number:09819859346