RE: CAE Excel add-in -- MIDRANGE-L

Dennis

After starting the Excel wizard, after you enter the file name, the next
screen gives three push buttons, data options, format options &
properties; press the data options, which will bring up the SQL
statement.  For users unsure of SQL press the Details push button which
allows the user to select fields, where statements & order by.

HTH

Regards
Andy 

|-----Original Message-----
|From: Dennis Munro [mailto:DMunro@xxxxxxxxxxxxxxxxxxxx]
|Sent: 22 October 2003 18:06
|To: Midrange List (E-mail)
|Subject: CAE Excel add-in
|
|V5R2M0
|
|Where can I find the manual (or something) that would explain what can
be
|done with the transfer to Excel add-in as far as programming the
details
|"Select || Where || Order By" tabs.  What I am trying to do is figure
out
|if
|I can PROMPT the user to enter the from & thru dates vs. having to hard
|code
|them in.  I hoping I could let them change the dates every time which
would
|be something similar to the RUNQRY RCDSLT(*YES) format.
|
|Again, I just want to find out if I can PROMPT the user for the dates &
|change the WHERE clause.  I know I can code them & have the user change
|them
|each time but this is a non power user so the simpler the better.
|
|I've spent way too many hours looking at the archives & the info center
&
|just must not be coming up with the correct search pattern.
Frustrating.
|
|Thanks - Dennis.
|
|Dennis Munro
|
|"I love deadlines.  I especially like the whooshing sound they make as
they
|go flying by."  Dilbert's Words Of Wisdom:
|
|Badger Mining Corporation
|www.badgerminingcorp.com
|dmunro@xxxxxxxxxxxxxxxxxxxx
|(920) 361-2388
|
|The information contained in this e-mail message is confidential
|information
|intended only for the use of the individual or entity named above. If
the
|reader of this message is not the intended recipient, or the employee
or
|agent responsible to deliver it to the intended recipient, you are
hereby
|notified that any dissemination, distribution or copying of this
|communication is strictly prohibited. If you have received this
|communication in error, please immediately notify us by telephone, and
|return the original message to us at the below address via the U.S.
Postal
|Service, and delete it from your computer.  Badger Mining Corporation
P.O.
|Box 328  Berlin, WI 54923  920-361-2388
|_______________________________________________
|This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
|To post a message email: MIDRANGE-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit: http://lists.midrange.com/mailman/listinfo/midrange-l
|or email: MIDRANGE-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at 
http://archive.midrange.com/midrange-l.--------------------------------------------------------
 
FormaServe Systems Ltd 
91 Redland Drive 
Loughton 
Milton Keynes 
Bucks  UK 
MK5 8FL 
 
T: +44 (0)1908 609500 
W:www.FormaServe.Co.Uk 
    www.iSeriesTraining.Co.Uk 
E: Info@xxxxxxxxxxxxxxxx 
--------------------------------------------------------
 
 
This message (and any associated files) is intended only for the use of 
midrange-l@xxxxxxxxxxxx and may contain information that is confidential, 
subject to copyright or constitutes a trade secret.  
If you are not midrange-l@xxxxxxxxxxxx you are hereby notified that any 
dissemination, copying or distribution of this message, or files associated 
with this message, is strictly prohibited.  
If you have received this message in error, please notify us immediately by 
replying to the message and deleting it from your computer.  
Messages sent to and from us may be monitored.  
Any views or opinions presented are solely those of Andy Youens and do not 
necessarily represent those of FormaServe Systems. 
 
 
 
 
 
 
 
--------------------------------------------------------