I have recorded a few scripts using Script Recording & Playback to automate a few functions in my department e.g. Populate sales deals with records, maintain various fields in the customer master etc. I use excel to populate “variable” data such as sales deal numbers, customer numbers, material numbers etc. then I use VBA loops to create additional VBS script and to copy and paste the new script to a VBS script file. The scripts work very well except when a record has already been created or the maintenance to a customer record has already occurred and therefore there is nothing to save. When this happens a message is displayed on the status bar and the script then stops. I have been trying to find a method of trapping this event so that I can attempt to build an “error” or “if” statement. The following script is an example of the sales deal record creation and I would really appreciate it of someone could give me a bit of advice.
