|
|
| CUSTOM EXCEL WORKBOOK SOFTWARE At CB Solutions we help clients harness technology and the Internet to do what they do with less effort, in less time and using less MONEY thereby increasing their profits. Our Excel Visual Basic applications are FULLY customisable and applicable to a wide variety of uses - this package being just one of many examples. We look forward to helping you become more productive in the routine data recording, analysis and report generation tasks that you do using MS Excel. Tayo Solagbade
What do you do with
MS Excel that you wish you could do quicker and more accurately?
Send
us a message to let us know what you want us to do for
you. |
0.1 System
Requirements 0.1 System requirements for using the Automated Excel VB Spreadsheet Application. NOTE! For this program to run properly you need the following: a. The full Excel Visual
Basic module installed in your copy of your Excel application.
Also, please check and ensure the copy of MS Excel you want to
use has the “Analysis ToolPak” and “Analysis
ToolPak – VBA” add-ins installed. This is to enable
certain spreadsheet functions used in the application perform
needed calculations. On the Excel Main Menu, click “Tools,
Add-Ins...” and confirm the check boxes for the earlier
mentioned add-ins are checked. If they are not, click on them
to do so. You will need to insert the MS Office installation disk
in the CD drive for this to work. b. We strongly recommend
that the application itself be located in the folder
in which we deliver it to clients - AND that folder, we recommend
be located in the root (C:\, D:\ etc)
of your PC's hard drive. This is the only way to ensure optimal
performance at all times. In particular it will ensure you do
not experience any difficulties locating the worksheets you create
using the EXPORT SHEET command button in the
application. c. Your system should have
minimum 256 MB RAM/20GB HD - or something close.
Note that 512 MB RAM would afford better performance over time,
as this application will grow in size/data volume processing requirements
as data is progressively added over 12 months. d. This program was
built using MS Excel 2003® . We advise that you run
it using the same or higher version - though we are certain, from
tests we've done, that most of the features are unlikely to malfunction
in MS Excel 2002, but not lower.
If you fail to read and follow the instructions
below you may find that our application will fail to run on the
PC you select. Also, note that these instructions MUST be applied
EVERY TIME you wish to use the application on
a PC that you have not used for that purpose previously. a. Copy the folder WITH it’s entire contents – as delivered to you - to your PC’s hard drive root(“C:\, D:\ ”). b. Note that if you downloaded
the application from our website, then the folder would have come
in a zipped format(.zip extension) to you. In such a case, you
will need to use WinZip or any other suitable file compression
software to unzip the folder BEFORE you copy it to the earlier
specified location on your PC hard drive.
0.3 Opening/running the application for the first time in your copy of MS Excel The application was created using MS Excel Visual Basic, and therefore requires that MS Excel’s Macro Security Setting be set to allow macros to run normally on it. Except you already use other workbooks that
require macros to be enabled, the Default Macro security setting
in your copy of Excel is likely to be minimum of "High"
which will cause applications like ours to be automatically disabled.
You will therefore need to use the following procedure to enable the macro: a. Close the file and any other
instances of the application currently running on the computer
(this may include closing any applications using portions of the
application you are currently running, such as Outlook which can
use Word, database applications, and others). Do NOT save the
application if prompted to do so by Excel. b. Select the Tools menu option and then select Macro and Security. In the resulting Security dialog, set the security level to Medium by clicking the Medium radio button. Close the file and any other instances of the application currently running on the computer. c. Open the application again
and click the Enable button when prompted to allow for the unsigned
macro to run. NOTE: In the event that you
do purchase any of our applications, you may want to set the security
level to "Low" by clicking the "Low" radio
button. This will eliminate the need to answer the "Enable/Disable
Macros" prompt every time you open the application. Keep
in mind however that this should only be done if you are sure
adequate anti-virus protection exists on your PC as other macros-driven
applications (from other sites you might patronize) could pose
virus-attack threats. d. When you have accepted the macro, return the macro security level to High. IF OUR APPLICATION STILL DOES NOT RUN, TROUBLESHOOTING TIPS THAT SHOULD HELP YOU FIND OUT WHY AND HOW TO RECTIFY THE PROBLEM are available in Troubleshooting tips - Questions and Answers
See Troubleshooting tips - Questions and Answers This Software Is Provided For Evaluation Only,
On An "As Is" Basis. The Author* Disclaims All Warranties
Relating To This Software, Whether Expressed Or Implied, Including
But Not Limited To Any Implied Warranties Of Merchantability Or
Fitness For A Particular Purpose. The Author* Shall Not Be Liable
For Any Indirect, Consequential, Or Incidental Damages Arising
Out Of The Use Or Inability To Use Such Software, Even If The
Author Has Been Advised Of The Possibility Of Such Damages Or
Claims. The Person Using The Software Bears All Risk As To The
Quality And Performance Of The Software. Although Every Effort
Has Been Made To Ensure The Accuracy Of This Program, Users Should
Verify The Results For Themselves. *The Author Is Tayo
Solagbade |
