search for: worksheetfunct

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/

...cult to understand whether the error depends on VB, on my R code, or on the interface of the two environments! Thanks in advance for any suggestions you might have Peter ------------------- VB Code --------------------------------- Dim Link_Ratio() As Double [...] No_of_Years = Application.WorksheetFunction.Count(Worksheets("InputTriangle").Range("C15:IV15")) ReDim Triangle(No_of_Years, No_of_Years) ReDim Link_Ratio(No_of_Years) [...] ' Calling some R functions Call rinterface.RunRFile(Functions_String) ' Input For ID_Col = 1 To No_of_Years Link_Ratio(ID_Col) = Wo...