Problem with excel file
Hi,
For my tests I use excel files. To read them, I use the method ExcelDriver like this :
Set driverExcel = DDT.ExcelDriver(pathFile,sheet, True)
If my excel file is already open (in read and write) and if i run my test. I get this error :
"The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data"
If the excel file is open in read-only, of course the error above disappears.
I would like to know if it's possible to run my test with my excel file open in read and write?
Thanks.
For my tests I use excel files. To read them, I use the method ExcelDriver like this :
Set driverExcel = DDT.ExcelDriver(pathFile,sheet, True)
If my excel file is already open (in read and write) and if i run my test. I get this error :
"The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data"
If the excel file is open in read-only, of course the error above disappears.
I would like to know if it's possible to run my test with my excel file open in read and write?
Thanks.
