IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Whither Scripting? Forum / Excel VBA
Post #373,340
by altmann
4/3/13 3:00:07 PM
Reply
New Excel VBA
Could have used VBA to pull in the file contents.
Post #373,343
by boxley
4/3/13 3:30:30 PM
Reply
New Re: Excel VBA, couldn't remember any :-)
Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free American and do not reflect the opinions of any person or company that I have had professional relations with in the past 57 years. meep
Post #373,387
by pwhysall
Picture of pwhysall
4/4/13 1:57:21 AM
Reply
New F1, or record the macro, or use a fancy pants
text import.

I use an unholy combination of C#, Python, Excel and sed to munge data around (don't ask, it's one of those things where the progenitor of the thing that makes the report files did that thing where the output looks pretty on screen but is actually about as machine-readable as a punch in the face) these days.
     up an odious creek sans paddle - (boxley) - (20) - April 2, 2013, 04:26:12 PM EDT
         Sounds like an ideal application for Python. - (Another Scott) - (5) - April 2, 2013, 04:32:45 PM EDT
             cannot use external software - (boxley) - (4) - April 2, 2013, 04:48:27 PM EDT
                 Will "sort" help? It's there in Winders. "sort /?" -NT - (Another Scott) - (2) - April 2, 2013, 05:16:22 PM EDT
                     its there but I need to remember how to do loops in - (boxley) - (1) - April 2, 2013, 05:22:36 PM EDT
                         Here... - (folkert) - April 2, 2013, 05:26:14 PM EDT
                 Now you know... - (folkert) - April 2, 2013, 05:19:13 PM EDT
         The sort of thing I'd use Emacs for - (malraux) - (6) - April 2, 2013, 07:48:23 PM EDT
             no emacs -NT - (boxley) - (5) - April 2, 2013, 08:56:36 PM EDT
                 Its downloadable - (folkert) - (4) - April 2, 2013, 09:30:56 PM EDT
                     He can't download anything... -NT - (malraux) - (2) - April 2, 2013, 10:01:27 PM EDT
                         download it at home - (lincoln) - (1) - April 3, 2013, 09:25:11 AM EDT
                             Not worth the risk. - (Another Scott) - April 3, 2013, 09:57:55 AM EDT
                     NSA DOD rules in place -NT - (boxley) - April 3, 2013, 09:59:14 AM EDT
         How does the filename convert to the cell reference? -NT - (scoenye) - (1) - April 3, 2013, 07:45:55 AM EDT
             file name references a spec - (boxley) - April 3, 2013, 10:01:24 AM EDT
         Small files fitting in a spreadsheet? - (crazy) - April 3, 2013, 07:47:40 AM EDT
         better, added statement to bash script to include - (boxley) - (3) - April 3, 2013, 01:30:01 PM EDT
             Excel VBA - (altmann) - (2) - April 3, 2013, 03:00:07 PM EDT
                 Re: Excel VBA, couldn't remember any :-) -NT - (boxley) - (1) - April 3, 2013, 03:30:30 PM EDT
                     F1, or record the macro, or use a fancy pants - (pwhysall) - April 4, 2013, 01:57:21 AM EDT

#include <stdlrpd.h>
99 ms