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


Groups > comp.lang.clipper.visual-objects > #3128 > unrolled thread

Export to Excel 2010

Started byIan <ithomson@mikroaid.co.uk>
First post2012-03-13 06:55 -0700
Last post2012-03-19 17:21 -0700
Articles 20 on this page of 46 — 12 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

Page 2 of 3 — ← Prev page 1 [2] 3  Next page →


#3173

From"Ginny Caughey" <gcaughey@hotmail.com>
Date2012-03-15 19:48 -0400
Message-ID<4f627fd0$0$2097$c3e8da3$9f400e27@news.astraweb.com>
In reply to#3170
Hi Willie,

It's a perfectly good concept and perhaps one day with the Portable Library 
project we'll get there (although I doubt very much that Vulcan will ever 
participate in that). We were nearly there with Windows Mobile .NET Compact 
Framework and .NET Framework but then things got more complicated.

Ginny

"Willie Moore"  wrote in message news:jjte25$1ci$1@speranza.aioe.org...

Ginny,

Adding Silverlight support would not allow a Vulcan program to run but it
would allow a class library containing my business logic to run from c#.
Ultimately I will probably keep my logic in the WCF component it live in. I
was just looking to try some new ways. Right now my cafeteria managers have
to print the register reports off from each register and then go back and
enter them from a web site connected via VPN. The web site makes calls into
my WCF component that handles the add/change/deletes. What I would like to
be able to offer them is a tablet or smartphone running a mobile entry form
and have them be able to do their work at the point where they gather the
data. If I could drop the dll containing my business logic onto the smart
device, I might have better response but then again I might now. That is
just a concept I am thinking about.

Regards,
Willie
Vulcan VIP

"Ginny Caughey"  wrote in message
news:4f620124$0$3998$c3e8da3$b23f186d@news.astraweb.com...

Hi Willie,

I understand why you use Vulcan, but I don't believe adding Silverlight
support to Vulcan would allow you to run code on Windows Phone. Just use C#
since you are fluent in it.

Ginny

"Willie Moore"  wrote in message news:jjsps1$99c$1@speranza.aioe.org...

Ginny,

For me, I like the VO/Vulcan syntax which is why I use it. I am fluent in c#
and vb.net and will use those languages when I need to or the contract calls
for it. As you know, the only language choices for Windows Phone are vb and
c# but the WCF services that you call from them can be written in anything.
I have been asking for Silverlight support in Vulcan so I can use the
business classes that I have written directly on devices without having to
put them in a WCF component.

Knowing that I can use reflector and move my code to another language if I
needed to is a plus. I am thankful that Grafx has preserved the VO syntax in
Vulcan.

Regards,
Willie
Vulcan VIP 

[toc] | [prev] | [next] | [standalone]


#3174

Fromnicktekhne@googlemail.com
Date2012-03-16 03:16 -0700
Message-ID<3825194.684.1331893011258.JavaMail.geo-discussion-forums@vbkc1>
In reply to#3170
Hi Willie,

Just looking on, as we're also actively working with WCF at the moment (though in C#). I'm curious to know what it is that keeps you from moving more of your business logic behind the WCF services? We're at a very early stage, so probably haven't hit the same type of practical issues as you yet, but our aim at the moment is to keep as much of the business logic on the server as possible, and transmit simple "pre-processed" objects to and from the clients.

The intention of this is to keep the clients as light and simple as possible a)for program distribution and maintenance, and b) to allow easy porting to other client devices, such as data entry from Android or Windows mobiles, and also to make data transmission via WCF as light as possible.

Nick

On Thursday, March 15, 2012 6:57:12 PM UTC, Willie Moore wrote:
> Ginny,
> 
> Adding Silverlight support would not allow a Vulcan program to run but it 
> would allow a class library containing my business logic to run from c#. 
> Ultimately I will probably keep my logic in the WCF component it live in. I 
> was just looking to try some new ways. Right now my cafeteria managers have 
> to print the register reports off from each register and then go back and 
> enter them from a web site connected via VPN. The web site makes calls into 
> my WCF component that handles the add/change/deletes. What I would like to 
> be able to offer them is a tablet or smartphone running a mobile entry form 
> and have them be able to do their work at the point where they gather the 
> data. If I could drop the dll containing my business logic onto the smart 
> device, I might have better response but then again I might now. That is 
> just a concept I am thinking about.
> 
> Regards,
> Willie
> Vulcan VIP
> 
> "Ginny Caughey"  wrote in message 
> news:4f620124$0$3998$c3e8da3$b23f186d@news.astraweb.com...
> 
> Hi Willie,
> 
> I understand why you use Vulcan, but I don't believe adding Silverlight
> support to Vulcan would allow you to run code on Windows Phone. Just use C#
> since you are fluent in it.
> 
> Ginny
> 
> "Willie Moore"  wrote in message news:jjsps1$99c$1@speranza.aioe.org...
> 
> Ginny,
> 
> For me, I like the VO/Vulcan syntax which is why I use it. I am fluent in c#
> and vb.net and will use those languages when I need to or the contract calls
> for it. As you know, the only language choices for Windows Phone are vb and
> c# but the WCF services that you call from them can be written in anything.
> I have been asking for Silverlight support in Vulcan so I can use the
> business classes that I have written directly on devices without having to
> put them in a WCF component.
> 
> Knowing that I can use reflector and move my code to another language if I
> needed to is a plus. I am thankful that Grafx has preserved the VO syntax in
> Vulcan.
> 
> Regards,
> Willie
> Vulcan VIP

[toc] | [prev] | [next] | [standalone]


#3176

From"Willie Moore" <williem@wmconsulting.com>
Date2012-03-16 08:54 -0500
Message-ID<jjvgmi$anv$1@speranza.aioe.org>
In reply to#3174
Nick,

I currently use WCF and it works great. I am just exploring other options. 
The part I don’t like about calling WCF from Windows Phone is that I cannot 
call a method and have it directly return my result. I have to add an event 
for method completion and pick up my results from it. That just complicates 
the design a bit.

Regards,
Willie
Vulcan VIP

wrote in message 
news:3825194.684.1331893011258.JavaMail.geo-discussion-forums@vbkc1...

Hi Willie,

Just looking on, as we're also actively working with WCF at the moment 
(though in C#). I'm curious to know what it is that keeps you from moving 
more of your business logic behind the WCF services? We're at a very early 
stage, so probably haven't hit the same type of practical issues as you yet, 
but our aim at the moment is to keep as much of the business logic on the 
server as possible, and transmit simple "pre-processed" objects to and from 
the clients.

The intention of this is to keep the clients as light and simple as possible 
a)for program distribution and maintenance, and b) to allow easy porting to 
other client devices, such as data entry from Android or Windows mobiles, 
and also to make data transmission via WCF as light as possible.

Nick

On Thursday, March 15, 2012 6:57:12 PM UTC, Willie Moore wrote:
> Ginny,
>
> Adding Silverlight support would not allow a Vulcan program to run but it
> would allow a class library containing my business logic to run from c#.
> Ultimately I will probably keep my logic in the WCF component it live in. 
> I
> was just looking to try some new ways. Right now my cafeteria managers 
> have
> to print the register reports off from each register and then go back and
> enter them from a web site connected via VPN. The web site makes calls 
> into
> my WCF component that handles the add/change/deletes. What I would like to
> be able to offer them is a tablet or smartphone running a mobile entry 
> form
> and have them be able to do their work at the point where they gather the
> data. If I could drop the dll containing my business logic onto the smart
> device, I might have better response but then again I might now. That is
> just a concept I am thinking about.
>
> Regards,
> Willie
> Vulcan VIP
>
> "Ginny Caughey"  wrote in message
> news:4f620124$0$3998$c3e8da3$b23f186d@news.astraweb.com...
>
> Hi Willie,
>
> I understand why you use Vulcan, but I don't believe adding Silverlight
> support to Vulcan would allow you to run code on Windows Phone. Just use 
> C#
> since you are fluent in it.
>
> Ginny
>
> "Willie Moore"  wrote in message news:jjsps1$99c$1@speranza.aioe.org...
>
> Ginny,
>
> For me, I like the VO/Vulcan syntax which is why I use it. I am fluent in 
> c#
> and vb.net and will use those languages when I need to or the contract 
> calls
> for it. As you know, the only language choices for Windows Phone are vb 
> and
> c# but the WCF services that you call from them can be written in 
> anything.
> I have been asking for Silverlight support in Vulcan so I can use the
> business classes that I have written directly on devices without having to
> put them in a WCF component.
>
> Knowing that I can use reflector and move my code to another language if I
> needed to is a plus. I am thankful that Grafx has preserved the VO syntax 
> in
> Vulcan.
>
> Regards,
> Willie
> Vulcan VIP 

[toc] | [prev] | [next] | [standalone]


#3177

From"Ginny Caughey" <gcaughey@hotmail.com>
Date2012-03-16 11:10 -0400
Message-ID<4f635808$0$9116$c3e8da3$12bcf670@news.astraweb.com>
In reply to#3176
Hi Willie,

But that's the way all the SDKs are moving and provides better 
responsiveness for the client. Much of winrt is asynchronous even on the 
desktop. Are you planning any winrt apps? Maybe you could use Vulcan for 
that if you're determined. ;-)

Ginny

"Willie Moore"  wrote in message news:jjvgmi$anv$1@speranza.aioe.org...

Nick,

I currently use WCF and it works great. I am just exploring other options.
The part I don’t like about calling WCF from Windows Phone is that I cannot
call a method and have it directly return my result. I have to add an event
for method completion and pick up my results from it. That just complicates
the design a bit.

Regards,
Willie
Vulcan VIP

wrote in message
news:3825194.684.1331893011258.JavaMail.geo-discussion-forums@vbkc1...

Hi Willie,

Just looking on, as we're also actively working with WCF at the moment
(though in C#). I'm curious to know what it is that keeps you from moving
more of your business logic behind the WCF services? We're at a very early
stage, so probably haven't hit the same type of practical issues as you yet,
but our aim at the moment is to keep as much of the business logic on the
server as possible, and transmit simple "pre-processed" objects to and from
the clients.

The intention of this is to keep the clients as light and simple as possible
a)for program distribution and maintenance, and b) to allow easy porting to
other client devices, such as data entry from Android or Windows mobiles,
and also to make data transmission via WCF as light as possible.

Nick

On Thursday, March 15, 2012 6:57:12 PM UTC, Willie Moore wrote:
> Ginny,
>
> Adding Silverlight support would not allow a Vulcan program to run but it
> would allow a class library containing my business logic to run from c#.
> Ultimately I will probably keep my logic in the WCF component it live in. 
> I
> was just looking to try some new ways. Right now my cafeteria managers 
> have
> to print the register reports off from each register and then go back and
> enter them from a web site connected via VPN. The web site makes calls 
> into
> my WCF component that handles the add/change/deletes. What I would like to
> be able to offer them is a tablet or smartphone running a mobile entry 
> form
> and have them be able to do their work at the point where they gather the
> data. If I could drop the dll containing my business logic onto the smart
> device, I might have better response but then again I might now. That is
> just a concept I am thinking about.
>
> Regards,
> Willie
> Vulcan VIP
>
> "Ginny Caughey"  wrote in message
> news:4f620124$0$3998$c3e8da3$b23f186d@news.astraweb.com...
>
> Hi Willie,
>
> I understand why you use Vulcan, but I don't believe adding Silverlight
> support to Vulcan would allow you to run code on Windows Phone. Just use 
> C#
> since you are fluent in it.
>
> Ginny
>
> "Willie Moore"  wrote in message news:jjsps1$99c$1@speranza.aioe.org...
>
> Ginny,
>
> For me, I like the VO/Vulcan syntax which is why I use it. I am fluent in 
> c#
> and vb.net and will use those languages when I need to or the contract 
> calls
> for it. As you know, the only language choices for Windows Phone are vb 
> and
> c# but the WCF services that you call from them can be written in 
> anything.
> I have been asking for Silverlight support in Vulcan so I can use the
> business classes that I have written directly on devices without having to
> put them in a WCF component.
>
> Knowing that I can use reflector and move my code to another language if I
> needed to is a plus. I am thankful that Grafx has preserved the VO syntax 
> in
> Vulcan.
>
> Regards,
> Willie
> Vulcan VIP 

[toc] | [prev] | [next] | [standalone]


#3183

From"Willie Moore" <williem@wmconsulting.com>
Date2012-03-17 07:11 -0500
Message-ID<jk1v1a$m8p$1@speranza.aioe.org>
In reply to#3177
Ginny,

I will ultimately move to the model too it is just another learning curve 
<g>.

Regards,
Willie
Vulcan VIP

"Ginny Caughey"  wrote in message 
news:4f635808$0$9116$c3e8da3$12bcf670@news.astraweb.com...

Hi Willie,

But that's the way all the SDKs are moving and provides better
responsiveness for the client. Much of winrt is asynchronous even on the
desktop. Are you planning any winrt apps? Maybe you could use Vulcan for
that if you're determined. ;-)

Ginny

"Willie Moore"  wrote in message news:jjvgmi$anv$1@speranza.aioe.org...

Nick,

I currently use WCF and it works great. I am just exploring other options.
The part I don’t like about calling WCF from Windows Phone is that I cannot
call a method and have it directly return my result. I have to add an event
for method completion and pick up my results from it. That just complicates
the design a bit.

Regards,
Willie
Vulcan VIP

wrote in message
news:3825194.684.1331893011258.JavaMail.geo-discussion-forums@vbkc1...

Hi Willie,

Just looking on, as we're also actively working with WCF at the moment
(though in C#). I'm curious to know what it is that keeps you from moving
more of your business logic behind the WCF services? We're at a very early
stage, so probably haven't hit the same type of practical issues as you yet,
but our aim at the moment is to keep as much of the business logic on the
server as possible, and transmit simple "pre-processed" objects to and from
the clients.

The intention of this is to keep the clients as light and simple as possible
a)for program distribution and maintenance, and b) to allow easy porting to
other client devices, such as data entry from Android or Windows mobiles,
and also to make data transmission via WCF as light as possible.

Nick

On Thursday, March 15, 2012 6:57:12 PM UTC, Willie Moore wrote:
> Ginny,
>
> Adding Silverlight support would not allow a Vulcan program to run but it
> would allow a class library containing my business logic to run from c#.
> Ultimately I will probably keep my logic in the WCF component it live in. 
> I
> was just looking to try some new ways. Right now my cafeteria managers 
> have
> to print the register reports off from each register and then go back and
> enter them from a web site connected via VPN. The web site makes calls 
> into
> my WCF component that handles the add/change/deletes. What I would like to
> be able to offer them is a tablet or smartphone running a mobile entry 
> form
> and have them be able to do their work at the point where they gather the
> data. If I could drop the dll containing my business logic onto the smart
> device, I might have better response but then again I might now. That is
> just a concept I am thinking about.
>
> Regards,
> Willie
> Vulcan VIP
>
> "Ginny Caughey"  wrote in message
> news:4f620124$0$3998$c3e8da3$b23f186d@news.astraweb.com...
>
> Hi Willie,
>
> I understand why you use Vulcan, but I don't believe adding Silverlight
> support to Vulcan would allow you to run code on Windows Phone. Just use 
> C#
> since you are fluent in it.
>
> Ginny
>
> "Willie Moore"  wrote in message news:jjsps1$99c$1@speranza.aioe.org...
>
> Ginny,
>
> For me, I like the VO/Vulcan syntax which is why I use it. I am fluent in 
> c#
> and vb.net and will use those languages when I need to or the contract 
> calls
> for it. As you know, the only language choices for Windows Phone are vb 
> and
> c# but the WCF services that you call from them can be written in 
> anything.
> I have been asking for Silverlight support in Vulcan so I can use the
> business classes that I have written directly on devices without having to
> put them in a WCF component.
>
> Knowing that I can use reflector and move my code to another language if I
> needed to is a plus. I am thankful that Grafx has preserved the VO syntax 
> in
> Vulcan.
>
> Regards,
> Willie
> Vulcan VIP 

[toc] | [prev] | [next] | [standalone]


#3184

From"Ginny Caughey" <gcaughey@hotmail.com>
Date2012-03-17 09:47 -0400
Message-ID<4f649610$0$31146$c3e8da3$b280bf18@news.astraweb.com>
In reply to#3183
hi Willie,

I do agree there! ;-)

Ginny

"Willie Moore"  wrote in message news:jk1v1a$m8p$1@speranza.aioe.org...

Ginny,

I will ultimately move to the model too it is just another learning curve
<g>.

Regards,
Willie
Vulcan VIP

"Ginny Caughey"  wrote in message
news:4f635808$0$9116$c3e8da3$12bcf670@news.astraweb.com...

Hi Willie,

But that's the way all the SDKs are moving and provides better
responsiveness for the client. Much of winrt is asynchronous even on the
desktop. Are you planning any winrt apps? Maybe you could use Vulcan for
that if you're determined. ;-)

Ginny

"Willie Moore"  wrote in message news:jjvgmi$anv$1@speranza.aioe.org...

Nick,

I currently use WCF and it works great. I am just exploring other options.
The part I don’t like about calling WCF from Windows Phone is that I cannot
call a method and have it directly return my result. I have to add an event
for method completion and pick up my results from it. That just complicates
the design a bit.

Regards,
Willie
Vulcan VIP

wrote in message
news:3825194.684.1331893011258.JavaMail.geo-discussion-forums@vbkc1...

Hi Willie,

Just looking on, as we're also actively working with WCF at the moment
(though in C#). I'm curious to know what it is that keeps you from moving
more of your business logic behind the WCF services? We're at a very early
stage, so probably haven't hit the same type of practical issues as you yet,
but our aim at the moment is to keep as much of the business logic on the
server as possible, and transmit simple "pre-processed" objects to and from
the clients.

The intention of this is to keep the clients as light and simple as possible
a)for program distribution and maintenance, and b) to allow easy porting to
other client devices, such as data entry from Android or Windows mobiles,
and also to make data transmission via WCF as light as possible.

Nick

On Thursday, March 15, 2012 6:57:12 PM UTC, Willie Moore wrote:
> Ginny,
>
> Adding Silverlight support would not allow a Vulcan program to run but it
> would allow a class library containing my business logic to run from c#.
> Ultimately I will probably keep my logic in the WCF component it live in. 
> I
> was just looking to try some new ways. Right now my cafeteria managers 
> have
> to print the register reports off from each register and then go back and
> enter them from a web site connected via VPN. The web site makes calls 
> into
> my WCF component that handles the add/change/deletes. What I would like to
> be able to offer them is a tablet or smartphone running a mobile entry 
> form
> and have them be able to do their work at the point where they gather the
> data. If I could drop the dll containing my business logic onto the smart
> device, I might have better response but then again I might now. That is
> just a concept I am thinking about.
>
> Regards,
> Willie
> Vulcan VIP
>
> "Ginny Caughey"  wrote in message
> news:4f620124$0$3998$c3e8da3$b23f186d@news.astraweb.com...
>
> Hi Willie,
>
> I understand why you use Vulcan, but I don't believe adding Silverlight
> support to Vulcan would allow you to run code on Windows Phone. Just use 
> C#
> since you are fluent in it.
>
> Ginny
>
> "Willie Moore"  wrote in message news:jjsps1$99c$1@speranza.aioe.org...
>
> Ginny,
>
> For me, I like the VO/Vulcan syntax which is why I use it. I am fluent in 
> c#
> and vb.net and will use those languages when I need to or the contract 
> calls
> for it. As you know, the only language choices for Windows Phone are vb 
> and
> c# but the WCF services that you call from them can be written in 
> anything.
> I have been asking for Silverlight support in Vulcan so I can use the
> business classes that I have written directly on devices without having to
> put them in a WCF component.
>
> Knowing that I can use reflector and move my code to another language if I
> needed to is a plus. I am thankful that Grafx has preserved the VO syntax 
> in
> Vulcan.
>
> Regards,
> Willie
> Vulcan VIP 

[toc] | [prev] | [next] | [standalone]


#3179

Fromnicktekhne@googlemail.com
Date2012-03-16 11:02 -0700
Message-ID<7044099.139.1331920972339.JavaMail.geo-discussion-forums@vbiz13>
In reply to#3176
Willie,

The issue I was driving at was the boundary between data, business and presentation logic, and what made your business logic fall outside the WCF services at the moment.

Because obviously the simpler the client side, the easier it is to support other platforms.

Nick

On Friday, March 16, 2012 1:54:24 PM UTC, Willie Moore wrote:
> Nick,
> 
> I currently use WCF and it works great. I am just exploring other options. 
> The part I don’t like about calling WCF from Windows Phone is that I cannot 
> call a method and have it directly return my result. I have to add an event 
> for method completion and pick up my results from it. That just complicates 
> the design a bit.
> 
> Regards,
> Willie
> Vulcan VIP
> 

[toc] | [prev] | [next] | [standalone]


#3182

From"Willie Moore" <williem@wmconsulting.com>
Date2012-03-17 07:09 -0500
Message-ID<jk1ut6$lre$1@speranza.aioe.org>
In reply to#3179
Nick,

Nothing fell out of the split between GUI and business logic. One thing I 
like to do with my local code is I design my business logic is to be inside 
of WCF but in reality I call the classes in my desktop apps directly instead 
of by wcf and just link the dll the same way I link any other dll. My web 
sites though reference the WCF component as it was designed.

I still use the same dll across clients, I just change the way the dlls are 
accessed. I hope this makes sense.

Regards,
Willie
Vulcan VIP

wrote in message 
news:7044099.139.1331920972339.JavaMail.geo-discussion-forums@vbiz13...

Willie,

The issue I was driving at was the boundary between data, business and 
presentation logic, and what made your business logic fall outside the WCF 
services at the moment.

Because obviously the simpler the client side, the easier it is to support 
other platforms.

Nick

On Friday, March 16, 2012 1:54:24 PM UTC, Willie Moore wrote:
> Nick,
>
> I currently use WCF and it works great. I am just exploring other options.
> The part I don’t like about calling WCF from Windows Phone is that I 
> cannot
> call a method and have it directly return my result. I have to add an 
> event
> for method completion and pick up my results from it. That just 
> complicates
> the design a bit.
>
> Regards,
> Willie
> Vulcan VIP
> 

[toc] | [prev] | [next] | [standalone]


#3186

Fromnicktekhne@googlemail.com
Date2012-03-18 04:04 -0700
Message-ID<19065093.441.1332068676155.JavaMail.geo-discussion-forums@ynnk21>
In reply to#3182
Hi Willie,

Understood. I'm just interested in this because we want to support some basic data entry/lookup type functions on other devices, so as we move forward we're trying to find the best way to separate out the different tiers of our application and make as much code as possible either sit behind the WCF services, or else have such a simple structure that it can be easily reproduced in a different environment (eg. Java on Android).

So I like to prod anyone who's done something similar for experiences and feedback on the practicalities.

Nick

On Saturday, March 17, 2012 12:09:14 PM UTC, Willie Moore wrote:
> Nick,
> 
> Nothing fell out of the split between GUI and business logic. One thing I 
> like to do with my local code is I design my business logic is to be inside 
> of WCF but in reality I call the classes in my desktop apps directly instead 
> of by wcf and just link the dll the same way I link any other dll. My web 
> sites though reference the WCF component as it was designed.
> 
> I still use the same dll across clients, I just change the way the dlls are 
> accessed. I hope this makes sense.
> 
> Regards,
> Willie
> Vulcan VIP
> 
> wrote in message 
> news:7044099.139.1331920972339.JavaMail.geo-discussion-forums@vbiz13...
> 
> Willie,
> 
> The issue I was driving at was the boundary between data, business and 
> presentation logic, and what made your business logic fall outside the WCF 
> services at the moment.
> 
> Because obviously the simpler the client side, the easier it is to support 
> other platforms.
> 
> Nick
> 
> On Friday, March 16, 2012 1:54:24 PM UTC, Willie Moore wrote:
> > Nick,
> >
> > I currently use WCF and it works great. I am just exploring other options.
> > The part I don’t like about calling WCF from Windows Phone is that I 
> > cannot
> > call a method and have it directly return my result. I have to add an 
> > event
> > for method completion and pick up my results from it. That just 
> > complicates
> > the design a bit.
> >
> > Regards,
> > Willie
> > Vulcan VIP
> >

[toc] | [prev] | [next] | [standalone]


#3168

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2012-03-15 17:06 +0100
Message-ID<ji44m7lhm326fsh4vtatb01mk6v79fh96v@4ax.com>
In reply to#3161
On Thu, 15 Mar 2012 07:50:54 -0500, "Willie Moore"
<williem@wmconsulting.com> wrote:

Hello Willie,
>
>If you are using the VulcanVOGUI then yes the dlls are all 32 bit. If you do 
>not use the Vulcan Runtime libraries, you can use corflag to reset the dlls 
>for "any cpu". 


But would the latter mean that Ian would be able to run Office
automation in all versions of Windows/Office with a Vulcan program as
mentioned in the link below?

If not, a Vulcan switch makes less sense than I thought it did as you
are still limited. I find it already a disadvantage that you can't use
Vulcan for Windows Phone development; although understanding M$ hard
linked this to their own products C# en VB. But I expect more and more
programs only to work with 64 bit applications.

>>
>>http://msdn.microsoft.com/en-us/library/dd941355.aspx
>>

Dick

[toc] | [prev] | [next] | [standalone]


#3169

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2012-03-15 17:15 +0100
Message-ID<ss44m7te244mptspk9juvdrn12585si5q8@4ax.com>
In reply to#3161
On Thu, 15 Mar 2012 07:50:54 -0500, "Willie Moore"
<williem@wmconsulting.com> wrote:

Hello Willie,
>
>How are your mobile apps doing? I need to submit the ones I showed you just 
>to see if I can get them through the process.
>

That would be very interesting. I decided to apply for the Website
Spark program to see what that would bring us. Under certain
conditions I didn't quite well understand you could get some free
software:

http://www.microsoft.com/web/websitespark/support.aspx?tab=ProgramDetails

At least I think it is handy if I have VS Professional to have Windows
Phone, eventuel future Vulcan and whatever else runs in VS in one
program instead of multiple Express versions (if I understand it
right, this would happen if you install these programs without a full
VS version). So we made a call to MS and the conditions they had on
their screens differed....

In short: we were accepted for a free MSDN membership (can you believe
that...they never read my messages in this NG I think <g>) and could
directly download/install the software mentioned in the link above.

So the tools are here...now the time and the effort. Any samples are
appreciated as a starting point.

Dick

[toc] | [prev] | [next] | [standalone]


#3135

From"Ginny Caughey" <gcaughey@hotmail.com>
Date2012-03-13 11:52 -0400
Message-ID<4f5f6d63$0$2022$c3e8da3$fdf4f6af@news.astraweb.com>
In reply to#3129
Why not just create a dbf file with your data and give it the .XLS 
extension? This has worked forever and still does on Windows 8:

METHOD LoadWks(cFilename AS STRING) AS VOID PASCAL CLASS CSIReportDialog
    LOCAL pRet AS PTR
    LOCAL dwRet AS DWORD
    LOCAL cError AS STRING


    pRet := ShellExecute(SELF:hWnd, NULL, PSZ(cFilename), NULL, 
PSZ(GetDefault()), SW_SHOWMINIMIZED)
    dwRet := DWORD(_CAST, pRet)
    IF dwRet <= 32    // Error occurred
        DO CASE
            CASE dwRet == 0 .OR. dwRet == SE_ERR_OOM
                cError := "Not enough memory"
            CASE dwRet == DWORD(ERROR_FILE_NOT_FOUND)
                cError := "File "+cFilename+" not found."
            CASE dwRet == SE_ERR_NOASSOC
                cError := "There is no application registered on this 
machine to handle files ending in .XLS"
            OTHERWISE
                cError := "An error occurred processing "+cFilename
        END CASE
        MessageBox(0, PSZ(cError), PSZ("Error"), MB_OK)
    ENDIF
    RETURN

Ginny

"Karl Wochele"  wrote in message news:9s92e4Far9U1@mid.individual.net...

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 

[toc] | [prev] | [next] | [standalone]


#3136

FromIan <ithomson@mikroaid.co.uk>
Date2012-03-13 09:36 -0700
Message-ID<af09cdb5-3ba9-4065-8af5-688c25d1ea3a@m2g2000vbc.googlegroups.com>
In reply to#3135
On Mar 13, 3:52 pm, "Ginny Caughey" <gcaug...@hotmail.com> wrote:
> Why not just create a dbf file with your data and give it the .XLS
> extension? This has worked forever and still does on Windows 8:
>
> METHOD LoadWks(cFilename AS STRING) AS VOID PASCAL CLASS CSIReportDialog
>     LOCAL pRet AS PTR
>     LOCAL dwRet AS DWORD
>     LOCAL cError AS STRING
>
>     pRet := ShellExecute(SELF:hWnd, NULL, PSZ(cFilename), NULL,
> PSZ(GetDefault()), SW_SHOWMINIMIZED)
>     dwRet := DWORD(_CAST, pRet)
>     IF dwRet <= 32    // Error occurred
>         DO CASE
>             CASE dwRet == 0 .OR. dwRet == SE_ERR_OOM
>                 cError := "Not enough memory"
>             CASE dwRet == DWORD(ERROR_FILE_NOT_FOUND)
>                 cError := "File "+cFilename+" not found."
>             CASE dwRet == SE_ERR_NOASSOC
>                 cError := "There is no application registered on this
> machine to handle files ending in .XLS"
>             OTHERWISE
>                 cError := "An error occurred processing "+cFilename
>         END CASE
>         MessageBox(0, PSZ(cError), PSZ("Error"), MB_OK)
>     ENDIF
>     RETURN
>
> Ginny
>
> "Karl Wochele"  wrote in messagenews:9s92e4Far9U1@mid.individual.net...
>
> 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 Ginny,

Thanks for the code, you are a star. Will try that later today.

Many thanks
Ian

[toc] | [prev] | [next] | [standalone]


#3137

FromJohan Nel <johan.nel@xsinet.co.za>
Date2012-03-14 01:07 -0700
Message-ID<ea0fd02d-9d91-4175-9b3e-6fc883ddfb63@h20g2000yqd.googlegroups.com>
In reply to#3135
Hi Ginny/Ian,

Did not realise it picks up DBF too.  I have used a similar trick
using HTML, just name it .xls and Excel will open it correctly.

Regards,

Johan Nel
Durban, South Africa.

On Mar 13, 5:52 pm, "Ginny Caughey" <gcaug...@hotmail.com> wrote:
> Why not just create a dbf file with your data and give it the .XLS
> extension? This has worked forever and still does on Windows 8:
>
> METHOD LoadWks(cFilename AS STRING) AS VOID PASCAL CLASS CSIReportDialog
>     LOCAL pRet AS PTR
>     LOCAL dwRet AS DWORD
>     LOCAL cError AS STRING
>
>     pRet := ShellExecute(SELF:hWnd, NULL, PSZ(cFilename), NULL,
> PSZ(GetDefault()), SW_SHOWMINIMIZED)
>     dwRet := DWORD(_CAST, pRet)
>     IF dwRet <= 32    // Error occurred
>         DO CASE
>             CASE dwRet == 0 .OR. dwRet == SE_ERR_OOM
>                 cError := "Not enough memory"
>             CASE dwRet == DWORD(ERROR_FILE_NOT_FOUND)
>                 cError := "File "+cFilename+" not found."
>             CASE dwRet == SE_ERR_NOASSOC
>                 cError := "There is no application registered on this
> machine to handle files ending in .XLS"
>             OTHERWISE
>                 cError := "An error occurred processing "+cFilename
>         END CASE
>         MessageBox(0, PSZ(cError), PSZ("Error"), MB_OK)
>     ENDIF
>     RETURN
>
> Ginny
>
> "Karl Wochele"  wrote in messagenews:9s92e4Far9U1@mid.individual.net...
>
> 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

[toc] | [prev] | [next] | [standalone]


#3141

From"Ginny Caughey" <gcaughey@hotmail.com>
Date2012-03-14 07:37 -0400
Message-ID<4f608316$0$2340$c3e8da3$76a7c58f@news.astraweb.com>
In reply to#3137
I didn't know that trick, but Excel is pretty smart. :)

"Johan Nel"  wrote in message 
news:ea0fd02d-9d91-4175-9b3e-6fc883ddfb63@h20g2000yqd.googlegroups.com...

Hi Ginny/Ian,

Did not realise it picks up DBF too.  I have used a similar trick
using HTML, just name it .xls and Excel will open it correctly.

Regards,

Johan Nel
Durban, South Africa.

On Mar 13, 5:52 pm, "Ginny Caughey" <gcaug...@hotmail.com> wrote:
> Why not just create a dbf file with your data and give it the .XLS
> extension? This has worked forever and still does on Windows 8:
>
> METHOD LoadWks(cFilename AS STRING) AS VOID PASCAL CLASS CSIReportDialog
>     LOCAL pRet AS PTR
>     LOCAL dwRet AS DWORD
>     LOCAL cError AS STRING
>
>     pRet := ShellExecute(SELF:hWnd, NULL, PSZ(cFilename), NULL,
> PSZ(GetDefault()), SW_SHOWMINIMIZED)
>     dwRet := DWORD(_CAST, pRet)
>     IF dwRet <= 32    // Error occurred
>         DO CASE
>             CASE dwRet == 0 .OR. dwRet == SE_ERR_OOM
>                 cError := "Not enough memory"
>             CASE dwRet == DWORD(ERROR_FILE_NOT_FOUND)
>                 cError := "File "+cFilename+" not found."
>             CASE dwRet == SE_ERR_NOASSOC
>                 cError := "There is no application registered on this
> machine to handle files ending in .XLS"
>             OTHERWISE
>                 cError := "An error occurred processing "+cFilename
>         END CASE
>         MessageBox(0, PSZ(cError), PSZ("Error"), MB_OK)
>     ENDIF
>     RETURN
>
> Ginny
>
> "Karl Wochele"  wrote in messagenews:9s92e4Far9U1@mid.individual.net...
>
> 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 

[toc] | [prev] | [next] | [standalone]


#3142

FromIan <ithomson@mikroaid.co.uk>
Date2012-03-14 05:39 -0700
Message-ID<3327ca4e-fa85-4383-84d6-7fd66f447b40@z31g2000vbt.googlegroups.com>
In reply to#3141
On Mar 14, 11:37 am, "Ginny Caughey" <gcaug...@hotmail.com> wrote:
> I didn't know that trick, but Excel is pretty smart. :)
>
> "Johan Nel"  wrote in message
>
> news:ea0fd02d-9d91-4175-9b3e-6fc883ddfb63@h20g2000yqd.googlegroups.com...
>
> Hi Ginny/Ian,
>
> Did not realise it picks up DBF too.  I have used a similar trick
> using HTML, just name it .xls and Excel will open it correctly.
>
> Regards,
>
> Johan Nel
> Durban, South Africa.
>
> On Mar 13, 5:52 pm, "Ginny Caughey" <gcaug...@hotmail.com> wrote:
>
>
>
> > Why not just create a dbf file with your data and give it the .XLS
> > extension? This has worked forever and still does on Windows 8:
>
> > METHOD LoadWks(cFilename AS STRING) AS VOID PASCAL CLASS CSIReportDialog
> >     LOCAL pRet AS PTR
> >     LOCAL dwRet AS DWORD
> >     LOCAL cError AS STRING
>
> >     pRet := ShellExecute(SELF:hWnd, NULL, PSZ(cFilename), NULL,
> > PSZ(GetDefault()), SW_SHOWMINIMIZED)
> >     dwRet := DWORD(_CAST, pRet)
> >     IF dwRet <= 32    // Error occurred
> >         DO CASE
> >             CASE dwRet == 0 .OR. dwRet == SE_ERR_OOM
> >                 cError := "Not enough memory"
> >             CASE dwRet == DWORD(ERROR_FILE_NOT_FOUND)
> >                 cError := "File "+cFilename+" not found."
> >             CASE dwRet == SE_ERR_NOASSOC
> >                 cError := "There is no application registered on this
> > machine to handle files ending in .XLS"
> >             OTHERWISE
> >                 cError := "An error occurred processing "+cFilename
> >         END CASE
> >         MessageBox(0, PSZ(cError), PSZ("Error"), MB_OK)
> >     ENDIF
> >     RETURN
>
> > Ginny
>
> > "Karl Wochele"  wrote in messagenews:9s92e4Far9U1@mid.individual.net...
>
> > 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,

Problem now sorted. Checked W7 pc and found that the office 2010
starter pack had been installed instead of the full office 2010
version. Thats why my method could not locate the application.excel in
the registry.

Regards,
Ian

[toc] | [prev] | [next] | [standalone]


#3147

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2012-03-14 20:16 +0100
Message-ID<pdr1m7ht26usdagdm4s9dtssiucd1opetc@4ax.com>
In reply to#3141
On Wed, 14 Mar 2012 07:37:35 -0400, "Ginny Caughey"
<gcaughey@hotmail.com> wrote:

Hello Ginny

>I didn't know that trick, but Excel is pretty smart. :)

I am surprised that Excel still accept the dbf-cdx rename trick and no
doubt M$ will "repair" that feature. From  Office 2007, the option to
export as dbf file has been removed. I get many data to be read in
dbf's via Excel and despite the fact that it never works without a lot
of trouble it's the quickest way.

Another reason, except far higher speed & the absence of the ribbon,
to keep using Office 2003.

Dick

[toc] | [prev] | [next] | [standalone]


#3148

FromIan <ithomson@mikroaid.co.uk>
Date2012-03-14 12:27 -0700
Message-ID<856d9a11-0d58-4471-afe9-c44b759e30cb@q11g2000vbu.googlegroups.com>
In reply to#3147
On Mar 14, 7:16 pm, D.J.W. van Kooten <pub...@ic2remove.this.com>
wrote:
> On Wed, 14 Mar 2012 07:37:35 -0400, "Ginny Caughey"
>
> <gcaug...@hotmail.com> wrote:
>
> Hello Ginny
>
> >I didn't know that trick, but Excel is pretty smart. :)
>
> I am surprised that Excel still accept the dbf-cdx rename trick and no
> doubt M$ will "repair" that feature. From  Office 2007, the option to
> export as dbf file has been removed. I get many data to be read in
> dbf's via Excel and despite the fact that it never works without a lot
> of trouble it's the quickest way.
>
> Another reason, except far higher speed & the absence of the ribbon,
> to keep using Office 2003.
>
> Dick

Hi,

Although Ginny's method worked and it is a nice simple routine to get
data into Excel, I am happier keeping the methods I have now as they
allow me to not only export data into Excel, they allow me to add
headers to the columns and specify fonts colours and a wide range of
other values that make the end result more pleasing to the Excel
user.  I reviewed Gerhard's suggestion about using ole-xlsfile but it
looks as though this only covers Excel versions 1997, 2003 and 2007.
There is no mention on their site of Excel 2010.

Thanks for all the suggestions and help. Glad to see the group is
still supporting VO and that there is still a good source of
experience and help to call upon.


Regards,
Ian

[toc] | [prev] | [next] | [standalone]


#3150

From"Gerhard Bunzel" <g.bunzel@domonet.de>
Date2012-03-14 21:19 +0100
Message-ID<jjquhf$v6f$1@news.m-online.net>
In reply to#3148
Ian,

>OLE XLSFile does not require Microsoft Excel installed.

With ole-xlsfile you are creating XLS-Files independent from Excel. These 
XLS-Files are working with 1997, 2003, 2007 and 2010. For reading Excel 
files, you have to create XLS and not XLSX-files. Thats the only limitation.

HTH

Gerhard



>Hi,
>
>Although Ginny's method worked and it is a nice simple routine to get
>data into Excel, I am happier keeping the methods I have now as they
>allow me to not only export data into Excel, they allow me to add
>headers to the columns and specify fonts colours and a wide range of
>other values that make the end result more pleasing to the Excel
>user.  I reviewed Gerhard's suggestion about using ole-xlsfile but it
>looks as though this only covers Excel versions 1997, 2003 and 2007.
>There is no mention on their site of Excel 2010.
>
>Thanks for all the suggestions and help. Glad to see the group is
>still supporting VO and that there is still a good source of
>experience and help to call upon.
>
>
>Regards,
>Ian 

[toc] | [prev] | [next] | [standalone]


#3149

From"Ginny Caughey" <gcaughey@hotmail.com>
Date2012-03-14 16:06 -0400
Message-ID<4f60fa79$0$59035$c3e8da3$dbd57e7@news.astraweb.com>
In reply to#3147
Hi Dick,

It makes perfect sense to me for Excel to continue to support importing 
legacy dbf files and allowing you to export them as something more 
mainstream.

Ginny

"D.J.W. van Kooten"  wrote in message 
news:pdr1m7ht26usdagdm4s9dtssiucd1opetc@4ax.com...

On Wed, 14 Mar 2012 07:37:35 -0400, "Ginny Caughey"
<gcaughey@hotmail.com> wrote:

Hello Ginny

>I didn't know that trick, but Excel is pretty smart. :)

I am surprised that Excel still accept the dbf-cdx rename trick and no
doubt M$ will "repair" that feature. From  Office 2007, the option to
export as dbf file has been removed. I get many data to be read in
dbf's via Excel and despite the fact that it never works without a lot
of trouble it's the quickest way.

Another reason, except far higher speed & the absence of the ribbon,
to keep using Office 2003.

Dick 

[toc] | [prev] | [next] | [standalone]


Page 2 of 3 — ← Prev page 1 [2] 3  Next page →

Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web