To put double quotes in a string in VBA one has to use double double quotes
str = "a string with a ""quoted"" word" On Jun 1, 2012, at 12:26 AM, Duncan Murdoch wrote: > On 12-05-31 4:40 PM, Bert Jacobs wrote: >> Hi, >> I'm trying to run on Windows 7 a scriptfile with Rscript.exe from within >> Excel 2010 with the following code: >> Call Shell(rPath& "\Rscript.exe C:\Work\Latest\_Test.R", vbHide) >> >> The good news is: the above code works perfectly, but ... >> >> If I add white spaces to my map directory, like: >> Call Shell(rPath& "\Rscript.exe C:\Work\Latest 1\_Test.R", vbHide) >> >> In the above case or the RScript.exe doesn't run the file anymore. >> Could someone explain to me how this comes and how I can deal with it? > > Probably you'll need to put the file path in quotes. I suspect either single > or double quotes will work. > > I don't know how to put quotes in a quoted string in Excel, but I imagine > there's a way. > > Duncan Murdoch > > ______________________________________________ > 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. ______________________________________________ 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.