Excel error

This is a file \\DMMobile.xlsx and this is a directory \\DMMobile. However, \\DMMobile could be a file without an extension. How does TestComplete know what you are referring to, if you have not explicitly defined the filename?

You're passing in a filename to getExcelData, should that not be SheetTitle? And the function name should be getExcelSheet as you are returning an excel sheet.

function getExcelData(filename)
{
    var excelFile = Excel.Open(envVarfolder + "\\DMMobile.xlsx");
    var excelSheet = excelFile.SheetByTitle(fileName);
    return excelSheet;
}

Name your variables and functions correctly, so that other people can easily read your code. 

With regards to the original error you are receiving, I suggest you create a new project, and write your code to read the appropriate data from your Excel file. Also, read the Excel file from a different location such as C:\Temp. This is just to test that reading of Excel works for you.

That good. We're making progress 😀

So it's either an issue with TC not having appropriate permissions to read from %userprofile% or your coding needs to be corrected.

See Configuring Your System, or speak to your IT.

Use Excel application to open the file and see what happens.

Can you upload your project & Excel file, so that I can have a look.

I don't want your actual project, just the new project that you had created to test that Excel works (which is now not working)

I was hoping you can share the scripts, so that I don't have to type this out to test it!

You are still not indenting your code!

Here's an example. My Excel spreadsheet looks like this,

And here's JavaScript code to read and open the URLs in Chrome and Edge,

function TestWeb()
{
    var excelFile = Excel.Open("C:\\temp\\Websites.xlsx");
    var excelSheet = excelFile.SheetByTitle("Websites");
    var rows = excelSheet.RowCount;
    var cols = excelSheet.ColumnCount;
    Log.Message("Rows: " + rows);
    Log.Message("Columns: " + cols);
    
    var browsers = ["chrome", "edge"];
    
    for (var x = 1; x <= rows; x++) {
        for (var y = 2; y <= cols; y++) {
            var url = excelSheet.Cell(y, x).Value
            Log.Message(url);
            
            for (var k = 0; k < browsers.length; k++) {
                Browsers.Item(browsers[k]).Run(url);
                var page = Sys.Browser(browsers[k]).Page("*");
            }
        }
    }
}

Make sure you fully understand what the code is doing, and how it's written, including layout.