|
PureBytes Links
Trading Reference Links
|
Gets interesting...............there are (minimaly?) three(3) choices available........
1. Your VB-application: VB to VBA application
-----------------------------------------------------------------
-availability to switch from VB to VBA in your VB-application (eg from within
your VB-application call on f.e. the Excel program and run VBA from inside
Excel to finish VBA off automaticaly returning back to your VB-program)
2. Your VB-application: object OLE container control
-----------------------------------------------------------------
-embeds objects(known as "PasteSpecial") via an OLE compatible application
(eg Excel, Word, MetaStock) without your user knowing it (though the sources need
to be available+accessable on your user's disk)
-uses an OLE control and the upfront in the source application file made selection
-via the OLE link
3. Your VB-application: object Automation control
-----------------------------------------------------------------
-simulates ("borrows" from) an Automation compatible application
(eg Excel, Word etc.) without your user knowing it (though the sources need
to be available+accessable on your user's disk)
-uses an ActiveX control and the source application's "internal" Automation language
-via an in the C:\Temp folder temperarily created "application"-file(read:Excel or Word file)
info:
General info on Run(ing applications) and Open(ing files) are given throughout the Hours.
Hour 22 -Adding OLE to a Program
http://www.informit.com/content/078970921X/chapter_7262.shtml
Hour 30 - Enhancing Programs with ActiveX Controls
http://www.informit.com/content/078970921X/chapter_7270.shtml
Title: VB5 Nightschool
Author: Greg Perry
Publisher: Que
ISBN: 078970921X
Publication Date: 5/16/97
Pages: 912
(Thanks to Daniel Martinez for updating the List on the availability of these free electronic
books and to MacMillan Publishers Co. for putting them on their websites).
Walter: I will take you up on your suggestions, eg will retest (or even manualy "rewrite" instead of
having a "recorded" module) the setup here, as perhaps (recorded+visable or invisable)
setting(s) might be the cause of my "NumLock problem".
Thanks for putting me onto the VBE-tip (where 2 know more then 1).
Best Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
Homepage http://home.planet.nl/~anthmaas
----- Original Message -----
From: "Walter Lake" <wlake@xxxxxxxxx>
To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
Sent: donderdag 8 juni 2000 4:47
Subject: VB running VBA
> Thanks for your email
>
> No ... I don't know much about VB running Excel with custom interfaces. You
> might want to check out this site. It's fairly new I think and a work in
> progress. Very interesting direction.
>
> Only a few traders program in VB that I know of. I'm pretty sure that Mark's
> program is in VB and I think that Steve had a programmer working in VB.
> Sorry, but it's hard to keep who's who and what's what, straight <G>
>
> http://tor-pw1.netcom.ca/~johnjaz/vba.htm
>
> The general site is here
>
> http://tor-pw1.netcom.ca/~johnjaz/excel.htm
>
> Best regards
>
> Walter
|