RE: CAE Excel add-in

["Scott Johnson" <sjohnson@xxxxxxxxxxxxx>]

Not sure how to control the CA download function within Excel thru programming,
but you could use VBA/ADO/SQL to code it in Excel directly.

Some Resources:
http://www.midrangeserver.com/mgo/mgo081503-story02.html
http://www.midrangeserver.com/mgo/mgo102203-story01.html
Search for ADO at http://www.midrangeserver.com/search/searchindex.html
http://www.midrangeserver.com/mgo/mgo080803-story01.html
http://www.sqlthing.com/Resources/resources.html

------------------------------------------------------
Scott P. Johnson
Senior Programmer/Analyst
IBM Certified Specialist - AS/400 RPG Programmer
Highsmith Inc.
W5527 Hwy 106, PO BOX 800
Fort Atkinson, WI 53538-0800
TEL:  920-563-9571                FAX:  920-563-7395
sjohnson@xxxxxxxxxxxxx
www.highsmith.com
------------------------------------------------------
>
> 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.
>