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]]
______________________________________________
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.
