Given this application, rewrite the macros in the workbook to run in the best, fastest, and cheapest manner, yet still display the worksheets exactly as before. This is an application that PaulMdx wrote for me that causes some Excel macros to run when you start the unpackaging process by double-clicking on it from the desktop. (If you press the Disable Macros button, then Alt-F11, you can check them out in the VB editor. If you ignore the Disable Macros dialog box and just go back to the desktop, you will see the .csv files just there for the taking.) They create and format the workbook exactly as I want but they are inefficient and run **very slowly** - like it takes a couple of hours for everything to finish.
If I can beat your time by modifying your deliverable, I will consider the job incomplete. I'm talking about things like:
1. rewriting to avoid the use of Select while looping and formatting,
2. improving and minimizing the existing variable set and it's declaration logic, etc.
BACKGROUND: This workbook is created on demand. The data comes from a database of time entries which are grouped by home department, staff, then working department by ColdFusion for export into .csv files. The files were packaged so that I didn't have to run the macros from the server via a COM object, which is unauthorized by Microsoft anyway.
## Deliverables
1) Complete source code of all work done.
2) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows running at least Excel 98. (All the users who are downloading this have Excel 2000 installed on their desktop.)
NOTE: The named ranges are there because at the time of formulating the .csv files, I don't know what the ranges are going to be ahead of time. Within each range name is encoded what home directory, what user, what working directory, etc. I need the summary from. Then I just reverse engineer all the named ranges once I can access the .csv file as a worksheet. The last worksheet contains references to the first three. It is this last worksheet that is exported into check writing software, ADP in this case. If you want to change the formulas, you'll have to work with me to change the way they are exported from Cold Fusion. I put the status bar stuff in there to give the user some feedback - some hope that they're actually making progress! :-)