Forum Discussion

Anastasia02's avatar
Anastasia02
New Contributor
18 days ago

Sys.OleObject. Microsoft Office (Word, Excel)

I want to get the properties and methods of an already running Microsoft Office (Word, Excel) application. For this I use OLE object but I get an error "This command is not available because no docu...
desktop testing
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
18 days ago

I'm not able to get this to work either, if I already have Excel opened. I would expect the spreadsheet to open.

function test4()
{
    let Excel = Sys.OleObject("Excel.Application");
    //let Excel = getActiveXObject("Excel.Application");
    Sys.Process("explorer").Window("Shell_TrayWnd", "", 1).Activate();
    //Excel.Visible = true;
    Excel.Workbooks.Open("C:\\Temp\\Book2.xlsx");
    aqUtils.Delay(5000);
    Excel.Quit();
}

I suggest you open a support ticket via https://support.smartbear.com/testcomplete/message/