|
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. >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.