search for: putarrayfromvba

Hi List, Is there any way to pass on directly VBA variable content into a R variable? on windows XP & using R 2.12.0 I have installed RExcel addin (with associated D(COM)) >> It function fine when trying to pass Excel Range to R but I failed (sorry if it is only my own limitation, search till now unsuccessful) to find out how to pass directly VBA array into R Below an example -

...tions_String) ' Input For ID_Col = 1 To No_of_Years Link_Ratio(ID_Col) = Worksheets("Projection").Cells(Start_Row, Start_Col + ID_Col - 1).Value Use(ID_Col) = Worksheets("Projection").Cells(Start_Row + 1, Start_Col + ID_Col - 1).Value Next ID_Col Call rinterface.PutArrayFromVBA("link_ratio", Link_Ratio) Call rinterface.RRun("fitted_lr <- link_fit_vec(link_ratio)") Fitted_LR = rinterface.GetArrayToVBA("fitted_lr") ---------------------------- END OF VB code ------------------------------------------- At this point the code execution st...