[R] Excel Add-Ins Not Loaded When Using excel.link & RDCOM

Ayhan Yuksel @yh@n@yuk@el @ending from @lph@techt@com
Tue May 29 15:52:37 CEST 2018


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



More information about the R-help mailing list