Error: Unable to resolve the name workbooks.Open.

19 views (last 30 days)
Hello--
I'm trying to make a copy of an excel file (based on a template) and place the new file in a different folder. I was wondering if this error could be diagnosed...The error is:
Unable to resolve the name workbooks.Open.
Error in Excel_experiment (line 5)
wbsource = workbooks.Open('E:\Users\bpeoples\Downloads\MATLAB GLOSS
MEASUREMENTS\TemplateExcelFile\Template_Lightness.xlsx');
My code is as follows:
clc
close all
clear all
excel = actxserver('Excel.Application'); %start excel
wbsource = workbooks.Open('C:\Users\bpeoples\Downloads\MATLAB GLOSS MEASUREMENTS\TemplateExcelFile\Template_Lightness.xlsx');
wbdest = workbooks.Open('C:\Users\bpeoples\Downloads\MATLAB GLOSS MEASUREMENTS\Excel Files\someotherexcelfile.xlsx');
ws = wbsource.Worksheets.Item('NameOfSheet'); %or you can you the sheet index: ws = wbsource.Worksheets.Item(index);
ws.Copy(wdest.Worksheets.Item(1)); %copy worksheet before 1st worksheet of destination workbook
wdest.Save %save destination workbook
excel.Quit %quit excel

Accepted Answer

Fangjun Jiang
Fangjun Jiang on 29 Jun 2020
Edited: Fangjun Jiang on 29 Jun 2020
After excel = actxserver(), you have not defined "workbooks". Need this?
workbooks= excel.Workbooks;

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!