PC Review


Reply
Thread Tools Rate Thread

Batch execution of Excel with auto refresh

 
 
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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:29 AM.