I have some data that I would like to automatically manipulate in excel and then use to populate fields in an as400 form. Any suggestions on how to do this?
I tried just recording a macro and going to the appropriate place and entering some data just to get a starting point but I'm afraid I didn't get anything. I'm not unfamiliar with vba macros but I've never attempted to work outside of the excell file.
I tried just recording a macro and going to the appropriate place and entering some data just to get a starting point but I'm afraid I didn't get anything. I'm not unfamiliar with vba macros but I've never attempted to work outside of the excell file.