Edit... 5/5

AIG SunAmerica, Los Angeles, CA

Project: Excel Workbook Rollup Application, Access 2003
This application coded in VBA, manipulated thousands of Excel workbooks remotely. A master Excel file was created based the latest IRS forms and requirements. Many macros, links, calculations, and MS Queries were installed in its worksheets. After the master file was made, the Rollup application opened about 2000 Excel files remotely one at a time to update their content (worksheets deleted and reinserted and the links were repaired) per master Excel file while keeping their data content intact. The operation was handled in a matter of two hours compared to two months of manual work otherwise. The macros and the MS Queries in the master Excel file were propagated to 2000 remote Excel files as well.

Project: Excel Mass Print, Visual Studio 2005
Developed this smart application to boost office productivity thus saving a substantial amount of operation cost. Utilized in depth understanding of Excel Macro automation. Management described this tool as very helpful and gave a half day off for the increased productivity. The users were able to view their workbooks from different folders along with their worksheet tab names on one screen without navigating through company’s file explorer. Users were able to perform many common operations like selecting number of workbooks along with some of the tabs in them to print all at once. Compared to manual method of printing, 10 workbooks each with 5 worksheets selected required about 150 clicks, compared to 5 clicks using this solution. There were many other features included with this system to be discussed later.

Project: Admin-worksheet, Excel 2003
Admin worksheet was designed and added to the Excel production workbooks to help the Office Manager maintain a good degree of control over the security, naming conventions, and formatting styles throughout the workbooks to maintain uniformity and consistency. This resulted in ease of operation and productivity.

SQL-Server Data Conversion, Access 2003
This application was designed to assist with SQL-Server data, insert, update, and drop. Instead of entering the data record-by-record, it allowed the Managers to mass handle large number of records at once after series of data quality control prior to the execution.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Some thoughts for your consideration:
===============================

Project: Excel Workbook Rollup Application, Access 2003
 This application coded in VBA manipulated thousands of Excel workbooks remotely. A master Excel file was created based on the latest IRS forms and requirements. Many macros, links, calculations, and MS Queries were installed in its worksheets. After the master file was made, the Rollup application opened about 2000 Excel files remotely one at a time to update their content per master Excel file while keeping their data content intact (worksheets deleted and reinserted and the links repaired). The operation was handled in a matter of two hours compared to two months of manual work otherwise. The macros and the MS Queries in the master Excel file were propagated to 2000 remote Excel files as well.

 Project: Excel Mass Print, Visual Studio 2005
 Developed this smart application to boost office productivity which saved a substantial amount of operation cost. Utilized an in-depth understanding of Excel Macro automation. Management described this tool as very helpful and gave a half-day off for the increased productivity. The users were able to view their workbooks from different folders along with their worksheet tab names on one screen without navigating through company’s file explorer. Users were able to perform many common operations like selecting number of workbooks along with some of the tabs in them to print all at once. Compared to manual method of printing (10 workbooks each with 5 worksheets selected requiring about 150 clicks), compared to 5 clicks using this new solution. There were many other features included with this system to be discussed later.

 Project: Admin-worksheet, Excel 2003
 Admin worksheet was designed and added to the Excel production workbooks to help the Office Manager maintain a good degree of control over security, naming conventions, and formatting styles throughout the workbooks to maintain uniformity and consistency. This resulted in ease of operation and productivity.

 SQL-Server Data Conversion, Access 2003
 This application was designed to assist with SQL-Server data, insert, update, and drop. Instead of entering the data record-by-record, it allowed the managers to handle large number of records at one time (after a series of data quality control procedures prior to the execution).
=========================

I have changed wording to help the flow of the paragraphs. See what you think.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Thank you.
JohnBusiness Consultant (Owner)Commented:
You are most welcome, Mike, and I was happy to help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Proofreading

From novice to tech pro — start learning today.