> -----Original Message-----
> Behalf Of Tim Valder
>
> I am continually deluged with users asking "can you send me
> that report in
> Excel?". Well, I can, but not without getting involved in
> converting it.
[insert donna g. sigh here]
Umm, why not put the onus on the users to do [their own] work? After all, here is "an excel file":
1,2,3
3,4,5
8,7,4
Don't believe me? copy those three lines to a text file, NAME it with ".csv" as an extension, and open in excel...
But, you did start out with "...that report...", well, consider this portion of a "report":
Part Number Description Qty
001001-90-01 Product A 100
123456-78-90 Product B 2500
E1415 -00-01 Product C 15
Again, copy those four lines to a file and "open" in excel -- give the file some seemingly random extension such as ".txt" or ".prn", and you'll be pleasantly surprised to find excel will "figure out" that this is a FIXED WIDTH file and import properly [g'head -- I just did this myself to make sure my example would work]
In short, I think if you spend a few minutes training your users, you can relieve yourself from this burdon [some days it helps to think like tom sawyer or huck finn, if you know what I mean...]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|