Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110652

Re: Check how date is entered

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Check how date is entered
Date 2018-05-08 17:04 -0400
Organization A noiseless patient Spider
Message-ID <pct3co$9ap$1@dont-email.me> (permalink)
References (26 earlier) <pcs2kp$s2j$1@dont-email.me> <pcsd6c$12hj$1@gioia.aioe.org> <pcsreb$1sv9$1@gioia.aioe.org> <pcss7k$ko7$1@dont-email.me> <pcsvj0$4f6$1@gioia.aioe.org>

Show all headers | View raw

>
> Well, as the other follow-up comments, sometimes one doesn't have the choice 
> of what input format to use and I was trying to figure out how the OP could 
> solve his problem under those constraints.
>
> Sometimes ideal solutions are just not available in the real world.
>
> Can you illustrate the idea of the template for the ignorant? :)

Sure! (Though I don't consider you to be ignorant! You seem to be quite 
knowledgeable despite some unfamiliarity working in Excel after being so 
entrenched in MatLab)

My solutions, as you know from our collaboration project, are primarily *task 
oriented* to service repetative processing of data on a regular or period-based 
schedule. In cases where raw data is imported to a spreadsheet I'll pre-design 
a template to receive that data in its _expected_ format so it displays in the 
user's _desired_ format. After all, output data from most apps is usually just 
plain text. (CSV/TSV or the like)

Designing worksheets to receive raw or formatted data correctly is a critical 
part of my job as an Excel developer. Automating the solution is also another 
critical part of the job so it enhances user productivity in a consistent 
reliable manner.

Sometimes the data is stored in Excel files which may or may not have 
formatting, and sometimes the data is stored in a dbase (also with data type 
formatting). In both these cases I'd use ADODB to load the data into 
recordsets, then dump it into the worksheet which is already preformatted to 
receive it. (ergo a pre-designed template)

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Check how date is entered jan120253@gmail.com - 2018-05-04 00:31 -0700
  Re: Check how date is entered dpb <none@none.net> - 2018-05-04 07:46 -0500
    Re: Check how date is entered "Auric__" <not.my.real@email.address> - 2018-05-04 15:55 +0000
      Re: Check how date is entered dpb <none@none.net> - 2018-05-04 12:43 -0500
        Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 17:37 -0400
          Re: Check how date is entered dpb <none@none.net> - 2018-05-04 18:49 -0500
            Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 21:42 -0400
              Re: Check how date is entered dpb <none@none.net> - 2018-05-04 23:46 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 04:21 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 07:21 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 09:50 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 09:05 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 10:33 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 10:57 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 20:51 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 11:32 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 21:19 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-06 07:46 -0500
                Re: Check how date is entered dpb <none@none.net> - 2018-05-06 09:37 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 20:37 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-06 19:53 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 21:03 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 00:06 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 03:14 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 07:45 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:06 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:53 -0500
                Re: Check how date is entered malone <malone@nospam.net.nz> - 2018-05-08 08:19 +1200
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 15:35 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:38 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:26 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:19 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 01:31 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 07:45 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 09:45 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 14:34 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:09 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:06 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 13:48 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 15:02 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:59 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:04 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 18:53 -0500
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 21:12 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 23:51 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-09 07:20 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 11:32 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-09 11:35 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 15:03 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-09 15:18 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:34 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:44 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:40 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:50 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:02 -0400
  Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:45 -0700
    Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:52 -0700
      Re: Check how date is entered dpb <none@none.net> - 2018-05-07 08:16 -0500
        Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:10 -0400
  Re: Check how date is entered Ramon-México <cesaramon@gmail.com> - 2018-05-07 22:03 -0700

csiph-web