Originally Posted by biglad
I've had a couple beers, so sorry if the following makes little sense.
You should be able to access each Excel spreadsheet via the Excel COM API using powershell, vbs or any other windows based scrpting language - there is quite a lot of documentation out there - but you need to make sure the machine accessing the excel documents has Excel installed.
Have a search on google for vbs and excel and you should find plenty of examples:
Justkez.com » VBScript and Excel
Microsoft Excel VBScript Script samples
Drop me a PM if you need any help.
Rich.
|
Rich = Star, consider thyself repped, cheers for the links mate, will doubtless be on your back for more info, soon as I get some time to get onto it (which doesn't include now as I've just finished a 14 hr 'shift' - this be GF/TNF time baby!)