search for: thisworkbook

Hi all, This is a little off-topic, but it is on the general topic of getting data in R. I'm looking for a excel macro / vba script that will export all spreadsheets in a directory (with one file per tab) into csv. Does anyone have anything like this? Thanks, Hadley -- http://had.co.nz/

...erfectly. Over the samba server the virtual basic doesn't work at all. It means every time i want to do a macro (i've tested it in Word, Excell and Powerpoint) it answers me it can not save it. Even more, every time I open Excell it says that there is a compilation error on a hidded module: ThisWorkbook. Any suggestions? Really thanks Viktor Bautista i Roca. DRAC telem?tic http://www.drac.com/

Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It seems that Excel is opening the R console without any problems. The problem I am seeing is that Rinterface.RRun instruction is interpreting the "\T"