search for: savechanges

Hi, This may be due to several reasons. That I can think about: 1) Ensure you close *all* possibly open workbooks: nBooks <- xl[["Workbooks"]]$Count(); for (i in seq_len(nBooks)) xl[["Workbooks"]]$item(i)$Close(SaveChanges=FALSE); 2) The excel application reference does not seem to be really released until the garbage collector runs. So this may help: xl$Quit(); xl <- NULL; gc(); 3) Ensure you don't have any "hanging" reference to the excel application (sometimes from previous runs of your cod...

Hi guys, We already have some content to fill es/Repositories page ... When I tried to do so, an error appears saying that I have no access to change acl rights. That's rare to me because I'm just inserting content, no #acl line there . Do you know what this could be ? Thanks, al.

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/