- Joined
- Jun 24, 2008
- Messages
- 1
- Reaction score
- 0
I have an Excel spreadsheet which contains VB code to call a webservice via SOAP to extract data from a proprietary format. (I have to use the spreadsheet)
We need to have this spreadsheet executed every 15 minutes for use in constructing a database in an isolated network.
I need help with the following tasks:
1. How do I get the worksheet to refresh the SOAP call when opened?
2. How do I close the spreadsheet after the refresh?
We need to have this spreadsheet executed every 15 minutes for use in constructing a database in an isolated network.
I need help with the following tasks:
1. How do I get the worksheet to refresh the SOAP call when opened?
2. How do I close the spreadsheet after the refresh?