[R] Staging area for data before read into R

Ted Byers r.ted.byers at gmail.com
Tue Oct 21 23:09:30 CEST 2008


I wasn't suggesting that the validation requires VB.  

Creating forms and handling form events does (unless MS has introduced new
utilities to hide all that since last I used it).

Some of the most interesting things I have seen done with Excel did involve
VB, and there are better tools to do most of those things.

Gabor Grothendieck wrote:
> 
> On Tue, Oct 21, 2008 at 3:18 PM, Ted Byers <r.ted.byers at gmail.com> wrote:
>> There are tradeoffs no matter what route you take.
>> You can do validation in Access as you can in Excel, but Excel is not
>> designed to manage data where Access is, and both are crippled by their
>> dependance on VB (a seriouusly broken language: fine for scripting MS
> 
> Excel can do validation without VB.  For example, you can restrict
> data to a certain range of dates, limit choices by using a list, or
> make sure that only positive whole numbers are entered all without
> any VB.
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> 
> 

-- 
View this message in context: http://www.nabble.com/Staging-area-for-data-before-read-into-R-tp20075962p20099445.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list