Ed - have you tried the "tara" add-in? Regards, Devon On Mon, Oct 4, 2010 at 2:27 PM, Cox, Ed <[email protected]> wrote:
> To all, > Thanks for all the suggestions thus far. Unfortunately most are not viable > for what I need. I am handling large > extracts that can exceed well over 100k rows and multiple tabs from > multiple queries. The data are complex > medical terms, lab units, etc with all manner of data weirdness coming from > hospitals - including fun stuff like > unbalanced quotations. (That last plays havoc with the clip-board/paste > method I currently use.) Also, unfortunately > I am stuck having to use Excell due to MS being the supported platform in > the virtual server environment I am > constrained to due to patient privacy issues. > > To Bill, > I have tried playing with wdooo unsuccessfully. Unless there is some > language feature required in the scripts that > are not supported in j602 then I am seeing what appears to be some coding > issue in the wdooo script. (I tried > j701beta but did not make it very far.) In wdooo.ijs it was complaining > about (row 172): > VTSTR=: ; <@cut;._2 (0 : 0) > > > > Not knowing anything about what was going on I took a wild stab and > replaced it with: > > VTSTR=: ; <;._2 (0 : 0) > > > > Then I tried it and it died on this line in msexcel.ijs: > > 'me base temp'=: olecreate__p 'Excel.Application' > > > > When I tried olecreate__p 'Excel.Application' all by itself, it only > returned two values and not 3 as the calling line is > > looking for. I do note that an Excel process is being invoked, so at least > it is trying to do something. > > > > So at this point I am stuck. I don't know if any of that is enough to > suggest a solution to you or not. I realize I can't > > expect to go through tons of troubleshooting like this with you but hope > maybe there is just enough here to get to a > > solution if we are lucky enough that there are no othere issue but these. > > > > -Ed Cox > > > > _________________________________________________ > > This message is for the designated recipient only and may contain > privileged, proprietary > or otherwise private information. If you have received it in error, please > notify the sender > immediately and delete the original. Any other use of the email by you is > prohibited. > > Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - > Norsk - Portuguese > Svenska: www.carefusion.com/legal/email > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
