Forum Discussion

wynand_bwr's avatar
wynand_bwr
Occasional Contributor
13 years ago

Openig and Edit of Excel Spredsheet

Hi Can anyone please assist me in finding a easy way to open a excel spreadsheet and editing the data inside the sheet with TC? The sheet contains test data. I want to open the sheet at ...
wynand_bwr's avatar
wynand_bwr
Occasional Contributor
13 years ago
Hi



Thanks for the reply!!!



I came up with a solution myself last week.



What I did was create a VB script file with code. The created a .BAT that calls this file and executes it.



VBS :

Set aa = CreateObject("Excel.Application")

Set bb = aa.Workbooks.Open("C:\TC_Regression_Test_Data\TC_Regression_Test_Data.xls")

Set cc = aa.worksheets("Sheet1")

cc.Rows(2).Delete

bb.Save

aa.Workbooks.Close()



BAT :

@echo off

start c:\TC_Regression_Test_Data\TC3.vbs



pause