× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.