Sorry, I intended to send this straight to the rcom mailing list. It's about the rcom package.

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--- On Thu, 4/29/10, Albert-Jan Roskam <fomcl@yahoo.com> wrote:


From: Albert-Jan Roskam <fomcl@yahoo.com>
Subject: [R] UpdateLinks = FALSE
To: "R Mailing List" <r-help@r-project.org>
Date: Thursday, April 29, 2010, 1:07 PM


Hi,
 
I'm reading 100s of excel files and many of them contain links to external files (I hate that, but that aside). Every time such a file is opened, a menu pops up asking if I want to update the links. I never want to update the links. I used the macro recorder to see what code would be needed to suppress that message, but to no avail (I tried more variations, but one attempt is shown below).
How can I suppress such messages?
 
excel <- comCreateObject("Excel.Application")
wb <- comGetProperty(excel, "Workbooks")
comSetProperty(wb, "UpdateLinks", FALSE)
owb <- comInvoke(wb, "Open", xlsfile) # at this point, it's too late

Another query: the program at large erases any cells that contain formulae. Thanks to Erich, the program now works like a charm. However, some cells contain formulae such as "832.1 * E4 * E3"  (yes I know: big, big *sigh*). I did not take that possibility into account while writing the program. Would it be possible to capture the number (832.1)? My first idea would be to access the formula representation (as a string) and use a nifty regular expression.
 
Thank you in advance.

Cheers!!
Albert-Jan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


      
    [[alternative HTML version deleted]]


-----Inline Attachment Follows-----


______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.



      
	[[alternative HTML version deleted]]

