Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3140

Re: Export to Excel 2010

From Karl Wochele <kw@e﹐s-system.de>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Export to Excel 2010
Date 2012-03-14 11:43 +0100
Message-ID <9sbb2hFk83U1@mid.individual.net> (permalink)
References <154874e0-f1da-4418-9c76-8a43ad7d681b@l1g2000vbc.googlegroups.com> <9s92e4Far9U1@mid.individual.net> <bdbc9631-e057-4817-8cdb-df2572a67b0b@i2g2000vbv.googlegroups.com>

Show all headers | View raw


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<kw@e©os-system.de>  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

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-13 06:55 -0700
  Re: Export to Excel 2010 Karl Wochele <kw@e©os-system.de> - 2012-03-13 15:03 +0100
    Re: Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-13 07:14 -0700
      Re: Export to Excel 2010 Herberṫ Puṫz <newsgroupspam@mnet-online.de> - 2012-03-13 15:26 +0100
        Re: Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-13 08:18 -0700
          Re: Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-13 08:23 -0700
            Re: Export to Excel 2010 Herberṫ Puṫz <newsgroupspam@mnet-online.de> - 2012-03-13 16:31 +0100
      Re: Export to Excel 2010 Karl Wochele <kw@e©os-system.de> - 2012-03-14 11:43 +0100
        Re: Export to Excel 2010 D.J.W. van Kooten <public@ic2remove.this.com> - 2012-03-15 09:42 +0100
          Re: Export to Excel 2010 Karl Wochele <kw@e©os-system.de> - 2012-03-15 09:55 +0100
            Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-15 06:41 -0400
              Re: Export to Excel 2010 Karl Wochele <kw@e©os-system.de> - 2012-03-15 13:37 +0100
                Re: Export to Excel 2010 "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-03-15 19:09 +0000
                Re: Export to Excel 2010 Karl Wochele <kw@e©os-system.de> - 2012-03-19 13:42 +0100
          Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-15 06:43 -0400
            Re: Export to Excel 2010 "Willie Moore" <williem@wmconsulting.com> - 2012-03-15 07:50 -0500
              Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-15 09:02 -0400
                Re: Export to Excel 2010 "Willie Moore" <williem@wmconsulting.com> - 2012-03-15 08:12 -0500
                Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-15 10:47 -0400
                Re: Export to Excel 2010 "Willie Moore" <williem@wmconsulting.com> - 2012-03-15 13:57 -0500
                Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-15 19:48 -0400
                Re: Export to Excel 2010 nicktekhne@googlemail.com - 2012-03-16 03:16 -0700
                Re: Export to Excel 2010 "Willie Moore" <williem@wmconsulting.com> - 2012-03-16 08:54 -0500
                Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-16 11:10 -0400
                Re: Export to Excel 2010 "Willie Moore" <williem@wmconsulting.com> - 2012-03-17 07:11 -0500
                Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-17 09:47 -0400
                Re: Export to Excel 2010 nicktekhne@googlemail.com - 2012-03-16 11:02 -0700
                Re: Export to Excel 2010 "Willie Moore" <williem@wmconsulting.com> - 2012-03-17 07:09 -0500
                Re: Export to Excel 2010 nicktekhne@googlemail.com - 2012-03-18 04:04 -0700
              Re: Export to Excel 2010 D.J.W. van Kooten <public@ic2remove.this.com> - 2012-03-15 17:06 +0100
              Re: Export to Excel 2010 D.J.W. van Kooten <public@ic2remove.this.com> - 2012-03-15 17:15 +0100
    Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-13 11:52 -0400
      Re: Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-13 09:36 -0700
      Re: Export to Excel 2010 Johan Nel <johan.nel@xsinet.co.za> - 2012-03-14 01:07 -0700
        Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-14 07:37 -0400
          Re: Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-14 05:39 -0700
          Re: Export to Excel 2010 D.J.W. van Kooten <public@ic2remove.this.com> - 2012-03-14 20:16 +0100
            Re: Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-14 12:27 -0700
              Re: Export to Excel 2010 "Gerhard Bunzel" <g.bunzel@domonet.de> - 2012-03-14 21:19 +0100
            Re: Export to Excel 2010 "Ginny Caughey" <gcaughey@hotmail.com> - 2012-03-14 16:06 -0400
              Re: Export to Excel 2010 D.J.W. van Kooten <public@ic2remove.this.com> - 2012-03-14 22:35 +0100
  Re: Export to Excel 2010 "Gerhard Bunzel" <g.bunzel@domonet.de> - 2012-03-14 15:57 +0100
  Re: Export to Excel 2010 "Marc Verkade [Marti]" <marcatm@rti.nl> - 2012-03-15 22:36 +0100
    Re: Export to Excel 2010 Ian <ithomson@mikroaid.co.uk> - 2012-03-16 10:11 -0700
      Re: Export to Excel 2010 "Marc Verkade [Marti]" <marcatm@rti.nl> - 2012-03-16 22:49 +0100
  Re: Export to Excel 2010 Dieter <info@vulcandc.de> - 2012-03-19 17:21 -0700

csiph-web