I have been trying to import the phasing in capital data which is in the attached Excel file. I have added the identifiers on the attached word file. The data I am importing has numbers which I want AIMMS to convert to percentages.
On my side the PhasingInCapital is a worksheet inside the Input Data workbook. Here is the error:
ExcelSetActiveSheet(Input Data.xlsx, PhasingInCapital) failed: Workbook doesn't contain the specified sheet. Invalid index.
I have imported a lot of data files from Excel, I am not sure what am I doing wrong this time.
Best answer by mohansxView original