I want to create macros for 2 reasons
1. Testing - use a file as input run menu options to test that nothing has been broken ie Customer Master Entry screen needs 5 pieces of information and populates this information into 3 or 4 back ground files. If I could input the 5 fields from a file in a macro I could test this process each time a change is made
2. Conversion - If I need to load 100 new customers from another system, load the 5 fields into my file , run the macro , this will create the new master records.
I am currently doing the conversion by loading the files via CA/File Transfer - while this works , it gets complicated when you have to hit so many files and also you dont have the validation that the screen input fields would have, ie if the macro called existing input program all the valiadtion would be in place. This would mean user would need to monitor but that would only be for the exceptions.
Any feed back would be appreciated - I have seen this done once before about 10 years ago, but noone in my team has the details on how this was done.
AS400, Excel, Client Access
September 8, 2010 1:52 AM
September 8, 2010 1:01 PM