Displaying 1 result from an estimated 1 matches for "clearcontents".
2005 May 26
1
Help needed - Use of RSrvr in macro mode
...tion as follows :
Excel file : see attachment (one sheet named 'test', one cell A1
containing : smalltest(NA))
Macro :
Sub smalltest()
Range("A3").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Call RInterface.StartRServer
Call RInterface.RunRFile("h:\R-Sources\smalltest.r")
Windows("smalltest.xls").Activate
CommandString = Range("test!a1")
MsgBox (CommandString)
Call RInterface.RRun("CommandString")
Workbooks.Open Filena...