I'm trying to have my computer turn on at a scheduled time, then open MATLAB and run a set script to pull data from a website, process it, and output the results to Excel. I've been able to get everything working except the Excel bit. I've got the following lines to open and load an existing Excel file:
e = actxserver('Excel.Application');
eWorkbook = e.Workbooks.Open('C:\Users\USER_NAME_HERE\MATLAB\CoD Data.xlsx');
but it fails at the workbook loading line and gives me the following error in a logfile:
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Microsoft Excel cannot access the file 'C:\Users\USER_NAME_HERE\MATLAB\CoD Data.xlsx'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
Help File: xlmain11.chm
Help Context ID: 0
I've tried this with xlsread and gotten the same error. This script is being run 5 minutes or so after I have the computer scheduled to start. This file definitely exists and it's not being opened by any other program at startup. I'm wondering if maybe it's a permissions error or something, but I have no idea how to check or resolve that.