Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Karl Wochele Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Export to Excel 2010 Date: Wed, 14 Mar 2012 11:43:29 +0100 Lines: 67 Message-ID: <9sbb2hFk83U1@mid.individual.net> References: <154874e0-f1da-4418-9c76-8a43ad7d681b@l1g2000vbc.googlegroups.com> <9s92e4Far9U1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Trace: individual.net HL2Jik4RZ1s11ew0voIW8ggFdoXIfONtrGeZW4MF4Kde0q/gP4 Cancel-Lock: sha1:i1KHx9A4S3fB/Jdyxuozv7+K+t4= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 In-Reply-To: Xref: csiph.com comp.lang.clipper.visual-objects:3140 Hi Ian, sorry, wrong information from my side. Sometimes one shouldn't post before thinking twice... I mixed Excel with Outlook MAPI 64 bit which won't work with VO apps... http://msdn.microsoft.com/en-us/library/dd941355.aspx Karl Am 13.03.2012 15:14, schrieb Ian: > On Mar 13, 2:03 pm, Karl Wochele wrote: >> Hi Ian, >> >> probably your Excel is 64 bit and that won't work with a 32 bit VO app. >> Maybe there is a workaround, but i guess you will run into problems... >> >> HTH, >> Karl >> >> Am 13.03.2012 14:55, schrieb Ian: >> >> >> >>> Hi all, >> >>> When my app was running with Vo SP1 on Windows XP Pro I used a method >>> I downloaded from Marti's site that allowed me to export data from my >>> bBrowser displays to Excel 1997 or Excel 2003. >> >>> I have now updated VO to SP3, updated bBrowser to the latest patch and >>> moved to a Windows 7 Pro 64 bit pc that has Excel 2010 on it. >> >>> The export routine to Excel no longer works. The error message that is >>> shown is as follows; >> >>> OLE AutoObject has not been initialised or is already destroyed. >> >>> It could be the routines I got from Marti's site back in 2007 are no >>> longer valid with current versions of Excel and Windows OS. >> >>> Does anyone have any code they would share that would allow me to >>> export the highlighted rows in a bBrowser to Excel and then open the >>> Excel worksheet, that will not only cover the current Excel 2010 on my >>> Windows 7 PC, but which will still work with older versions of Excel >>> on Windows XP pc's. >> >>> Many thanks >> >>> Ian > > Hi Karl, > > Thanks for that. Never gave a thought to Excel 2010 being 64 bit. Will > build my app on windows 7 pc and test it on windows xp with Excel > 2003. If that still works ok then it is probably something to do with > Excel 2010 being 64 bit. > > Need to give thought as to whether that can be sorted or if I should > disable the routine if they are running Excel 2010. > > Thanks for the help. > > Ian