Batch execution of Excel with auto refresh

wally.randall wally.randall is offline

New Member

Join Date: Jun 2008

Posts: 1

24th Jun 2008

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?

« revert to xp home | Runtime 287 Error in Access »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
open excel 2007 refresh query from batch file	Brad Kelly	Microsoft Excel Programming	0	2nd Jun 2010 04:50 PM
Copy Excel functions formula and auto refresh refresh	Pauline Cheong	Microsoft Excel Worksheet Functions	3	16th Feb 2009 01:23 AM
How to refresh a Excel workbook with pivot & ADO query report in batch mode	Karen Middleton	Microsoft Excel Discussion	1	29th Apr 2005 02:05 PM
How to refresh a Excel workbook with pivot & ADO query report in batch mode	Karen Middleton	Microsoft Excel Misc	1	29th Apr 2005 02:05 PM
How to refresh a Excel workbook with pivot & ADO query report in batch mode	Karen Middleton	Microsoft Excel Programming	1	29th Apr 2005 02:05 PM