Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3128 > unrolled thread
| Started by | Ian <ithomson@mikroaid.co.uk> |
|---|---|
| First post | 2012-03-13 06:55 -0700 |
| Last post | 2012-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
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 →
| From | "Ginny Caughey" <gcaughey@hotmail.com> |
|---|---|
| Date | 2012-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]
| From | nicktekhne@googlemail.com |
|---|---|
| Date | 2012-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2012-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]
| From | "Ginny Caughey" <gcaughey@hotmail.com> |
|---|---|
| Date | 2012-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2012-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]
| From | "Ginny Caughey" <gcaughey@hotmail.com> |
|---|---|
| Date | 2012-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]
| From | nicktekhne@googlemail.com |
|---|---|
| Date | 2012-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2012-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]
| From | nicktekhne@googlemail.com |
|---|---|
| Date | 2012-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2012-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2012-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]
| From | "Ginny Caughey" <gcaughey@hotmail.com> |
|---|---|
| Date | 2012-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]
| From | Ian <ithomson@mikroaid.co.uk> |
|---|---|
| Date | 2012-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]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2012-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]
| From | "Ginny Caughey" <gcaughey@hotmail.com> |
|---|---|
| Date | 2012-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]
| From | Ian <ithomson@mikroaid.co.uk> |
|---|---|
| Date | 2012-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2012-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]
| From | Ian <ithomson@mikroaid.co.uk> |
|---|---|
| Date | 2012-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]
| From | "Gerhard Bunzel" <g.bunzel@domonet.de> |
|---|---|
| Date | 2012-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]
| From | "Ginny Caughey" <gcaughey@hotmail.com> |
|---|---|
| Date | 2012-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