Got Questions? Get Answers.
Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
How to you "auto-click" the update dialog in Excel sheets?

Subject: How to you "auto-click" the update dialog in Excel sheets?

From: Luna Moon

Date: 4 Mar, 2010 16:21:08

Message: 1 of 2

How to you "auto-click" the update dialog in Excel sheets?
When I access Excel sheet from Matlab, always a little window pops up,
"update the links", how do I automatically make it "yes"?

Subject: How to you "auto-click" the update dialog in Excel sheets?

From: Yair Altman

Date: 4 Mar, 2010 17:47:05

Message: 2 of 2

Luna Moon <lunamoonmoon@gmail.com> wrote in message <e5249fa6-de45-4c7c-b1c3-3d6e45b974fe@x22g2000yqx.googlegroups.com>...
> How to you "auto-click" the update dialog in Excel sheets?
> When I access Excel sheet from Matlab, always a little window pops up,
> "update the links", how do I automatically make it "yes"?

Assuming you use COM functionality to open/update/close your XLS (instead of using the built-in xlswrite function), open your XLS file with the optional second parameter (=UpdateLinks) as false. FYI, the full list of open() parameters is:

Workbooks.Open(FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad)

Yair Altman
http://UndocumentedMatlab.com

Tags for this Thread

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us