I collect data from a service that I would like to automate with VBA code. I have a list of codes that when given to a outside service over the internet supplies me with data I need. I wrote the following code, but it keeps opening up new Prompt windows as it walks through the codes. I would like it to only open 1 prompt window. The data retrieval of the data takes up to 5 second so I put a "Wait" statement into the VBA code. Here is the code:
The excel spreadsheet is a 2 column sheet with the code I send to the outside service is in column B. Column A is just a reference number 1 through x.Please Login or Register to view this content.
Thanks in advance!
Bookmarks