Repository navigation
Executing .R Files from VBA // German Umlaut #195
Description
Activity
Hi @samanthadtl
In relation to your first question if there is a way to run R files from VBA using BERT, the answer is yes. You can do the following in VBA:
Application.Run "BERT.Exec", "source('filePath.R')"
BERT.Exec will run any R code you provide as an argument. So you can combine BERT.Exec withsource()to run an R file from VBA.In relation to your second question, I encountered a similar issue with Portuguese special characters, such as "ç" or "ã". I didn't find any way to make it work, so my workaround was to just use different pathnames without any special characters.
Best regards
Hello everyone,
so far I was using RExcel and my company decided to switch to BERT from now on. I have all my R-code written in .R-files and used the RExcel command RInterface.RunRFile to execute it. Is there a similar easy and short command in BERT to run .R-files from VBA?
Also I tried to do some workarounds but another problem is that BERT doesn't get the german Umlaut. I have some pathnames that include an Umlaut (ä, ö, ü) but when using e.g. setwd("..") BERT keeps telling me "cannot change working directory".
Did anybody have a similar problem and found a solution for that? Thanks for any help!