wr_QLU
Quick Look-up utility for XLS/CSV files
Copyright 2003 Wolfgang Riesterer
All Rights Reserved

License Agreement

Except where otherwise noted, all of the documentation and programs included in this software package are:
Copyright 2003 Wolfgang Riesterer. All rights reserved.

This software package is provided "as-is," without any warranty of any kind. The author disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall the author or his suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if the author or his suppliers have been advised of the possibility of such damages by using this software package. Your use of this software package is entirely at your own risk.

This non-exclusive license agreement does not authorize you to: rent, lease, reverse engineer, de-compile, modify or disassemble the software package or its components.

You are hereby licensed to use this software package in a non-commercial (home/campus use only) environment. The ownership of this software package remains with the author. No redistribution without prior written permission.

By using this software package you indicate that you accepted this license agreement.

All trademarks or registered trademarks are property of their rightful owners.

HELP

wr_QLU
Quick Look-up utility for XLS/CSV files

Please read the license agreement before using this program: The use of this program is entirely at your own risk.

Do you need to provide easy means of looking up items from your XLS worksheet without the user needing to open up the worksheet application, and fumble with the FIND command, also avoiding corrupting your worksheet? wr_QLU looks-up items from one cell/field of your worksheet, and displaying the contents of a corresponding second cell. Your look up number (Call Numbers) should be consecutive numbers. To view all command line options see HELP / SET-UP.

The program uses native XLS and CSV files. Files without the XLS extension will be treated as CSV files. To use native XLS files, MS Excel and MS VBA must be installed on the computer where this program will run. Make sure, there are at least 2 columns/fields with requirements as specified in HELP.

Although the installation program for wr_QLU may make use of registry entries, wr_QLU does not! There are no dependencies other than the Windows operating system (except if you intend to use XLS files as explained above). If you intend to make just one single executable of wr_QLU available on your campus network then install it on a local hard drive first, and then copy all files except the "uninstall*.exe" file to the freshly created folder on your network drive. Maintenance becomes a snap. You then can safely uninstall wr_QLU from the local hard drive. To identify writing privileges on tightly controlled profiles it is mentioned that wr_QLU writes to the windows "temp" folder.

Several shortcuts of wr_QLU can be created, each pointing to different look-up databases but using only one single executable. Screen display can be highly customized. The difference in command line trail will distinguish between the various databases (see also /CF: option below).

Starting this program without any options on the command line will launch the demo database "wr_QLU.xls" as provided. The demo configuration file "wr_QLU.cfg" provided for your convenience contains all command tail options. The command line of your production program must contain at least the qualifying folder and file to your look-up data file.

Command line options (L. = label):
wr_QLU.exe [IN filename]/ML:[main L.]/WS:[sheet name]/SL:[search L.]/RL:[result L.] /BL:[blank L.]/HN:[high number]/LS:[last saved]/RF:[ result field in XLS/CSV file]/IF:[index field]/CF:[command file]/XC:{Y | N}


[in filename] must point to a valid XLS/CSV file with a least 2 columns/fields. Where /ML:, /SL:, /RL:, /BL:, /HN:, /LS: allow you to change the various displayed label names, and /RF: allows you to define the field in where your [result label] field resides in your IN (XLS/CSV) file. The /IF:[index field] must contain a number. Non-digit pre- and suffixes of numbers in [index field] will be removed. If you provided a XLS file and the worksheet in your workbook is not the first worksheet and not named "Sheet1" you must include the /WS: command option on the command line. Other defaults are: /RF:2/IF:1 (You may use also letters A through Z to identify the values of /RF and /IF values in your spreadsheet.). To turn off copying the database file from a network drive to a local drive before accessing it, use /XC:N (Y is the default).

Start this program up with the command line /CF:[command file] which points to a text file [command file] that can contain a much longer command line, which will be used instead.


All other options of the program's original command line will then be ignored.

The author appreciates any comments and testimonials, which may be published on the web site below.

 

www.wrUSA.net

Version notes:

2003-10-28 Added /XC:{Y|N} to copy data file first to local windows temp files folder to increase networked file reads. Default: /XC:Y - Win98SE reads fast on a slow computer, but W2k very slow on a fast computer. Other cosmetic changes to standardize look & feel.