Actxserver unable to locate Excel workbook

I am having issues getting the ActiveX application to open an existing Excel doc for editing.

My current code looks like:

file_name = 'Excel_Book.xlsx';
xl = actxserver('Excel.Application');
xlb = xl.Workbooks.Open(file_name);

This returns the error:

Error
Invoke Error, Dispatch Exception:
Source Microsoft Excel
Description: 'Excel_Book.xlsx' could not be found

I know that the file exists, as I can read it with

xlsread(file_name)

I have even changed the MATLAB directory to be seeing the folder with the Excel_Book file in it, and yet the ActiveX refuses to read the document.

Similar problems were encountered using:

xlb = xl.Workbooks.Item(file_name);
or
xlb = xl.get('Workbooks',file_name);

Answer 1

[Walter Roberson]

It would be safer to use fullfile() to create a fully-qualified file name to request to open.

[Bob Thompson]

Ok. Do you know if there is a quick and easy way of getting both the file name and the directory from user input. Something like:

filename = uigetfile
filedir = uigetdir

But all in one command? Or possibly a command to automatically get the directory from the user chosen file?

[Walter Roberson]

[filename, filedir] = uigetfile();
complete_file_name = fullfile(filedir, filename);

[Bob Thompson]

[filename, filedir] = uigetfile();

That second field is exactly what I needed, thanks.

Answer 2

[Shameer Parmar]

Try replacing the line and check..

 xlb = xl.Workbooks.Open(file_name);

with

 xlb = xl.Workbooks.Open('fullpath\file_name along with the extension');