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

Reply to this message
Add author to My Watch List
View original format
Flag as spam

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

Reply to this message
Add author to My Watch List
View original format
Flag as spam

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

Everyone's Tags:

excel, com

Add a New Tag:

Separated by commas
Ex.: root locus, bode

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.

Tag Activity for This Thread
Tag Applied By Date/Time
excel Yair Altman 4 Mar, 2010 12:49:10
com Yair Altman 4 Mar, 2010 12:49:10
rssFeed for this Thread

Contact us