Objective: To automate manual process to enter values for 3 separate fields (all 3 must be entered) and click on button that validates that the 3 pieces of information are VALID.
Tools: Excel 2010 vba (the only thing I have available to work with) and MS2003 Web Services Toolkit 2.01 installed.
I have taken examples from this website, as well as several other forums and articles, and have attempted coding a small program but there's always some minor syntax or run error that does NOT allow to work all the way.
I have entered the URL I want into the Web Service toolkit, and it created vba code for 3 classes. However, it has errors which does NOT allow a clean compilation. Also has run errors. I've tried both early binding as well as late binding, and same problem happens.
So what I need right now, is for somebody who is very familiar with this to help fill in the missing or incorrect portions of the code. Seems so simple and is so close but after almost 20 hours I can't figure it out and is due this Friday.
Once somebody answers I will attach the code I have so far.
Thank you
Submit an article or tip