[R] Staging area for data before read into R

[Ted Byers]

Ah, OK.  That is new since I used Excel last.

Thanks

On Tue, Oct 21, 2008 at 5:52 PM, Gabor Grothendieck
<ggrothendieck at gmail.com> wrote:
> You can create data entry forms without VB in Excel too.
>
> On Tue, Oct 21, 2008 at 5:09 PM, Ted Byers <r.ted.byers at gmail.com> wrote:
>>
>> 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.
>>
>> ______________________________________________
>> 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.
>>
>