Something seems to be **** slow these days, especially if there is embedded data....
Again now just the text only...
-----Ursprüngliche Nachricht-----
Von: Baranski, Detlef
Gesendet: Mittwoch, 5. April 2006 12:52
An: 'Dykema, Jim-P14701'; VRF
Betreff: AW: [vrf] - AxtiveX Question
Okay, you are using V7.5- great.
What you have to keep in mind is, that all activeX calls that are not in the excellib-menu are referenced to xlApp.
So if you copy the excel macro just enhance the xlApp in front of them, and it will work ( sometimes.,.,,) There have to be some changes in the word activex, too.
You forgot to do a () for the selection.paste .... In these cases you have to look in the device menu for the proper activeX syntax...
Hope the sample helps you to get beyond...
< Datei: Chart.xls >> < Datei: V75excelgraph2word.vee >>
best regards,
detlef
-----Ursprüngliche Nachricht-----
Von: Dykema, Jim-P14701 [mailto:Jim.Dykema@gdc4s.com]
Gesendet: Montag, 13. März 2006 20:59
An: VRF
Betreff: [vrf] - AxtiveX Question
I am trying to copy a embedded chart from Excel and pasting it to Word. I recorded the following macro in Excel and pasted it into VEE. I get the error message that "Variable was not found: ActiveSheet". I have the Microsoft Office Excel 9.0 Object Library selected under ActiveX Automation References. What am I missing?
ActiveSheet.ChartObjects("Chart 1").Activate; ActiveChart.ChartArea.Select; ActiveChart.ChartArea.Copy
Jim Dykema
GENERAL DYNAMICS
8201 E. McDowell Rd.
Scottsdale, AZ 85257
Phone: (480) 675-2104
FAX: (480) 441-3625
Pager Numeric: (877) 526-7062
Pager Text: 8775267062@skytel.com
Email: jim.dykema@gdc4s.com
---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Again now just the text only...
-----Ursprüngliche Nachricht-----
Von: Baranski, Detlef
Gesendet: Mittwoch, 5. April 2006 12:52
An: 'Dykema, Jim-P14701'; VRF
Betreff: AW: [vrf] - AxtiveX Question
Okay, you are using V7.5- great.
What you have to keep in mind is, that all activeX calls that are not in the excellib-menu are referenced to xlApp.
So if you copy the excel macro just enhance the xlApp in front of them, and it will work ( sometimes.,.,,) There have to be some changes in the word activex, too.
You forgot to do a () for the selection.paste .... In these cases you have to look in the device menu for the proper activeX syntax...
Hope the sample helps you to get beyond...
< Datei: Chart.xls >> < Datei: V75excelgraph2word.vee >>
best regards,
detlef
-----Ursprüngliche Nachricht-----
Von: Dykema, Jim-P14701 [mailto:Jim.Dykema@gdc4s.com]
Gesendet: Montag, 13. März 2006 20:59
An: VRF
Betreff: [vrf] - AxtiveX Question
I am trying to copy a embedded chart from Excel and pasting it to Word. I recorded the following macro in Excel and pasted it into VEE. I get the error message that "Variable was not found: ActiveSheet". I have the Microsoft Office Excel 9.0 Object Library selected under ActiveX Automation References. What am I missing?
ActiveSheet.ChartObjects("Chart 1").Activate; ActiveChart.ChartArea.Select; ActiveChart.ChartArea.Copy
Jim Dykema
GENERAL DYNAMICS
8201 E. McDowell Rd.
Scottsdale, AZ 85257
Phone: (480) 675-2104
FAX: (480) 441-3625
Pager Numeric: (877) 526-7062
Pager Text: 8775267062@skytel.com
Email: jim.dykema@gdc4s.com
---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like set ActiveSheet =...
Have a look in the example folder for the ActiveXautomation for excel what you have to do first ...
-----Ursprüngliche Nachricht-----
Von: Dykema, Jim-P14701 [mailto:Jim.Dykema@gdc4s.com]
Gesendet: Montag, 13. März 2006 20:59
An: VRF
Betreff: [vrf] - AxtiveX Question
I am trying to copy a embedded chart from Excel and pasting it to Word. I recorded the following macro in Excel and pasted it into VEE. I get the error message that "Variable was not found: ActiveSheet". I have the Microsoft Office Excel 9.0 Object Library selected under ActiveX Automation References. What am I missing?
ActiveSheet.ChartObjects("Chart 1").Activate;
ActiveChart.ChartArea.Select;
ActiveChart.ChartArea.Copy
 Jim Dykema
GENERAL DYNAMICS
8201 E. McDowell Rd.
Scottsdale, AZ 85257
Phone: (480) 675-2104
FAX: (480) 441-3625
Pager Numeric: (877) 526-7062
Pager Text: 8775267062@skytel.com
Email: jim.dykema@gdc4s.com
---
You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".Â
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
No you're not. Jeez, two in a row that are bound to get me in trouble!
No it doesn't support some of the concepts. In fact, it doesn't support any.
VEE exhibits absolutely NONE of the characteristics of any OO language to date. With the possible exception of a weak form of encapsulation. I don't care what the marketing literature says - these people carry degrees in business, psychology and (god forbid) liberal arts, not computer science. VEE is most emphatically not object oriented. At all. Just because it's written in an object oriented language doesn't mean it exhibits any OOness itself. If one wants to argue that VEE introduces it's own type of OOP then that's fine by me, but by other scales it scores almost zero.
Now, having said that let me also say that there's nothing forbidding the use of OO principals in VEE programming - just like every other kind of programming. It's the technique that makes the difference, not the language (I realize you get this by your verbiage by the way). The language can hinder or help the effort, but it doesn't make or break the technique.
Take your example: polymorphism. Consider a primitive case: C++ overloading. VEE has the Any type, and the typeName function returns the base type of Any. Therefore you can perform different actions depending on type: C++ overloading. Assuming of course that these Anys are inputs to a function or "object".
Now, for *real* polymorphism. I've actually seen routines that generate code on the fly and then execute it depending on conditions. Specifically, the value of parameters passed to a function, but the technique can be expanded to a program generator type scenario that would duplicate the function of a vtable. It's not like you're going to get anything like the speed of execution you'd want, but you could build a polymorphic function generator/executor.
Here's another example: C. Nobody I know would claim that C is particularly object oriented. This is in fact a language that hinders the concept more than helps it. And yet people were doing object oriented programming in C long before Bjorn stubbed his toe (or however the story goes). Windows is quite encapsulated and even polymorphic and yet it was written in C and up until recently sported an almost exclusively C API. The DCE RPC is almost a poster child for OO. One can almost see COM sprouting directly from RPC.
Ever since VEE 5 you can ignore VEE completely and do all your VEE programming with objects if you want. And now you can use .NET too and ignore VEE along another line of thought.
None of these abstractions really mean anything anyway. Sometimes they can help, but more often they hinder or hide. Just ask anybody who's familiar with MFC. It's a love/hate thing that goes right to the core of it's "object orientation".
The hiding is much more helpful, though that has it's bad points too. You don't *need* to know that a VB Collection is really a single linked list. Just go ahead and start using tens or hundreds of thousands of entries and you quickly find that an array of structures is a whole lot better choice. Same thing with a VB String. Don't try to grow it repeatedly or you'll find your beard growing while your disk thrashes.
In short, and as always, if the situation warrants then by all means use OO in VEE. Equally, if the situation warrants then use Patterns in VEE. Sometimes it's prudent to ignore all such abstractions and simply do VEE programming in VEE. Like I said, carpentry is not something you find in a lumber yard!
-SHAWN-
data....
Again now just the text only...
-----Ursprngliche Nachricht-----
Von: Baranski, Detlef
Gesendet: Mittwoch, 5. April 2006 12:52
An: 'Dykema, Jim-P14701'; VRF
Betreff: AW: [vrf] - AxtiveX Question
Okay, you are using V7.5- great.
What you have to keep in mind is, that all activeX calls that are not in the
excellib-menu are referenced to xlApp.
So if you copy the excel macro just enhance the xlApp in front of them, and
it will work ( sometimes.,.,,)
There have to be some changes in the word activex, too.
You forgot to do a () for the selection.paste .... In these cases you have
to look in the device menu for the proper activeX syntax...
Hope the sample helps you to get beyond...
< Datei: Chart.xls >> < Datei: V75excelgraph2word.vee >>
best regards,
detlef
-----Ursprngliche Nachricht-----
Von: Dykema, Jim-P14701 [mailto:Jim.Dykema@gdc4s.com]
Gesendet: Montag, 13. Mrz 2006 20:59
An: VRF
Betreff: [vrf] - AxtiveX Question
I am trying to copy a embedded chart from Excel and pasting it to Word. I
recorded the following macro in Excel and pasted it into VEE. I get the
error message that "Variable was not found: ActiveSheet". I have the
Microsoft Office Excel 9.0 Object Library selected under ActiveX Automation
References. What am I missing?
ActiveSheet.ChartObjects("Chart 1").Activate;
ActiveChart.ChartArea.Select;
ActiveChart.ChartArea.Copy
Jim Dykema
GENERAL DYNAMICS
8201 E. McDowell Rd.
Scottsdale, AZ 85257
Phone: (480) 675-2104
FAX: (480) 441-3625
Pager Numeric: (877) 526-7062
Pager Text: 8775267062@skytel.com
Email: jim.dykema@gdc4s.com
---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".