I need a Windows Service that updates an Excel object called "QueryTable" inside many? Excel Spreadsheets.
Once a day, this service must update the "Url" value of "QueryTable" object inside the Excel Spreadsheet and save the change in the spreadsheet to disk.
The Windows Service will run on its own server and will update approximately 500 spreadsheets per night.
We tried creating a similar app several years ago using COM to Excel Version 2003 and were not sucessful.? The server would run for a while, then crash.? Maybe now the latest version of Excel has new functionality that will allow it to work. Maybe you know of a 3rd party component that will perform this functionality.
Please do not respond unless you already have implemented a? Windows Service application like this.?
FYI -? QueryTable Object in Excel is described here:
<[url removed, login to view]>
The code to modify the QueryTable is as follows:
Set sheet1 = Workbooks(1).Worksheets(1)
Set qtData = [url removed, login to view] _
? ? ? .Add(Connection := "URL;http://datasvr/98q1/[url removed, login to view]", _
? ? ? ? ? ? ? Destination := [url removed, login to view](1,1))
? ? ? .WebFormatting = xlNone
? ? ? .WebSelectionType = xlSpecifiedTables
? ? ? **.WebTables** = "1,2"
? ? ? .Refresh
We will provide the service code.? You provide the component code to update the Spreadsheet and save it.
We are looking for proof of concept only.
If the Windows Service you create is able to load a single Excel Spreadsheet into memory (you can create your own spreadsheet), update the "[url removed, login to view]" property, then save the Excel Spreadsheet to disk 500 times, each file with a different filename (so we end up with 500 files), without crashing, and with reasonable performance (ie., not all night and not excessive memory consumption), then you are done.
* * *This broadcast message was sent to all bidders on Friday Oct 17, 2008 6:34:15 PM:
It is the end of the day here. I will get back to you again tomorrow morning. Thank you for your interest.
* * *This broadcast message was sent to all bidders on Monday Oct 20, 2008 3:49:07 PM:
I am close to accepting one of the existing bids. I expect to get approval today. Please discontinue any further analysis of this project until you have been notified that your bid has been selected. Thank you for your submissions!