If you are working in Microsoft Excel using the Excel Visual Basic programming language is a very good choice. sounds as if you need to look at the process of how the data is being entered, where it originates from etc. You may want to start by defining a stardard template format with set columns for the data. You may want to have an input form to help people enter the data and validate it. You can also set up worksheet validation to inforce the correct data entry for certian columns.
Some things to think about?
What people use the data.
What people enter the data.
Where are the files located.
How do they access the file. From a network folder or does everyone have a copy on their C:/ drive.
QUOTE(cdietschrun @ 17 Aug, 2009 - 07:07 AM)
At work a coworker has the need to automate some of his work. He has XLS files that have lots of blank columns and un-alphabetized entries in columns and he wants a version of that XLS that has been edited and adjusted and also has the ability to get appended to auotmatically later.
What way could I go about thinking how to design something to do this? What language to start in? I know there are programs out there that do this, but all I found are ones that charge and also he wouldn't be able to get the company to pay for a program to do this for him.
Any ideas/designs?
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
17 Aug, 2009 - 07:07 AM
| 
