R help - May 2018 - Excel Add-Ins Not Loaded When Using excel.link & RDCOM

Dear All,

I am using excel.link package to open and modify Excel files.

When I manually open Excel, all my add-ins are loaded without a problem.
But when I open Excel using excel.link package, like:
xls<-xl.get.excel()
xl.workbook.open("MyFile.xlsx")
some Excel add-ins are (installed but) not  loaded.

Since the problem is related to local add-ins at my side, I cannot
reproduce the problem here.

I am aware of how to solve this problem using VBA, but looking for a
solution within R, may be using RDCOM

Thanks
Ayhan

	[[alternative HTML version deleted]]

RDCOM supports calling R from Excel. AFAIK you need to use the non-free Statconn
software [1] to get much done going the other way.

FWIW I have found my life to be much simpler only using packages that access the
data in Excel rather than trying to control the software remotely. More
OS-portable, too. In fact, if you can obtain your data without having it ever
munged by Excel you may save yourself considerable headache with its
"helpful" misinterpretations of data. E.g. [2]

[1] http://sunsite.univie.ac.at/rcom
[2]
https://www.networkworld.com/article/2304425/lan-wan/excel-helpers-can-damage-data.html

On May 29, 2018 6:52:37 AM PDT, Ayhan Yuksel <ayhan.yuksel at
alphatecht.com> wrote:
>Dear All,
>
>I am using excel.link package to open and modify Excel files.
>
>When I manually open Excel, all my add-ins are loaded without a
>problem.
>But when I open Excel using excel.link package, like:
>xls<-xl.get.excel()
>xl.workbook.open("MyFile.xlsx")
>some Excel add-ins are (installed but) not  loaded.
>
>Since the problem is related to local add-ins at my side, I cannot
>reproduce the problem here.
>
>I am aware of how to solve this problem using VBA, but looking for a
>solution within R, may be using RDCOM
>
>Thanks
>Ayhan
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.
-- 
Sent from my phone. Please excuse my brevity.