Hi Nick The other link had some code to write back I think. The problem looks like creating a new sheet with ADO which doesn't seem possible. However I have dim distant recollections of ADOX (ADO Extension/ADO Extensibility library) with Access Jet and a quick google search for ADOX turned this up.
http://support.microsoft.com/kb/303814 Have a look and see if that's got it. Please let us know how you get on... Cheers -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of NickC Sent: 17 March 2008 09:37 To: 'ProFox Email List' Subject: RE: Getting at Excel data from VFP Graham, It certainly does work. I currently have a small test, albeit VB script, running on the server and reading from a spreadsheet. Excel is not installed on the server. Next problem is seeing if ADO can also write to the new spreadsheet! Thx for the ADO suggestion, Nick [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
