Passing data in VB forms and shellexec

Yahoo Archive
1
Ed,

If I shellexec a VB program to gather these
parameters,
can I then shellexec (or something similar) from the
VB program once I have the variables to execute a
different .EXE (not a VB program)???

Also, since I'm new to VB, can you give me any step-
by-step instructions for creating required modules for
your example - or some screen shots. I don't know
where to start in VB 6, which is what we have on our
system.

Thanks in advance.

Ed Kulbacki

--- "Giallombardo, Ed"
<egiallombardo@...> wrote:
> What you need to do for multiple fields is create a
> delimited clipboard
> value which you put together on the VB form and then
> dissassemble in Visual
> Basic.
> Here's an example for the VB syntax(no spaces after
> the equals sign:
>
> set
>
_cliptext={QuoteHed.Reference.scrvalue}","{QuoteHed.Quoted.scrvalue}
>
> Here's an example of the code in Visual Basic that
> would dissassemble the
> clipboard text into the different fields:
>
> Dim ClipText As String
> Dim Reference As String
> Dim Quoted As String
> Dim pos As Integer
> Dim i As Integer
> Dim Word As String
> Dim Ticker As Integer
>
> ClipText = Clipboard.GetText
> pos = 0
> Ticker = 0
>
> For i = 1 To Len(ClipText)
> Char = Mid(ClipText, i, 1)
>
> If Char = "," Then
> Word = Mid(ClipText, pos + 1, i - (pos +
> 1))
> pos = i
> Ticker = Ticker + 1
> Select Case Ticker:
> Case 1:
> Reference = Word
> Case 2:
> Quoted = Word
> End Select
> End If
>
>
> Ed Giallombardo
> Computer Technician
> Major Industries, Inc.
> 7120 Stewart Ave.
> Wausau, WI 54402
> phone: 715-842-4616 ext. 322
> email: egiallombardo@...
>
> -----Original Message-----
> From: bstenglein@...
> [mailto:bstenglein@...]
> Sent: Tuesday, September 04, 2001 8:26 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: passing data in VB forms and
> shellexec
>
>
> Ed,
>
> I have only tried this technique with 1 piece of
> data, I don't konw
> how you would make it work with more than that
> unless you set up
> multiple buttons, on the Vantage Basic form, each
> copying a piece of
> data to the clipboard, and I guess you could make
> multiple buttons on
> the Visual basic program pasting the data into the
> appropriate
> field. The limitation is that the Clipboard will
> only hold 1 item at
> a time, but with a little more user input I think
> you could make it
> work. I'm not sure how you would make it more
> automatic, but my
> Visual Basic skills are somewhat limited and rusty
> to boot.
>
> Brian Stenglein
>
> --- In vantage@y..., Ed Kulbacki <efkcon01@y...>
> wrote:
> > Brian,
> >
> > With the Visual Basic program, would it be
> possible
> > to pull in 3 or 4 pieces of data from the
> clipboard
> > as well as other data from elsewhere in the
> Vantage
> > system?
> >
> > Can you send me more details or snapshots of what
> > you have done?
> >
> > Ed
> >
> > --- bstenglein@c... wrote:
> > > Ed,
> > >
> > > I think you are talking about doing something
> > > similar to what I've
> > > done. I launch a Visual Basic Program from the
> > > QuoteMtl VB Form and
> > > I pass to it the Part Number from the screen
> before
> > > the VB Form by
> > > using the following commands.
> > >
> > > set _cliptext={QuoteMtl.PartNum.scrvalue}
> > > shellexec
> w:\vantage\vbforms\material\material.exe
> > >
> > > The first line puts the value of the PartNum
> field
> > > into the
> > > clipboard. And obviously the second line
> launches
> > > by VB Program.
> > > Then, when my Visual Basic Form Activates, it
> sets
> > > the focus in the
> > > field for PartNum and basically pastes the text
> from
> > > Vantage into
> > > that field. I am only doing this process for 1
> > > field, I believe
> > > there would be problems with trying to do it for
> > > multiple fields, but
> > > I haven't tried it.
> > >
> > > Private Sub Form_Activate()
> > >
> > > txtVantPartNum.SetFocus
> > >
> > > Screen.ActiveControl.SelText = Clipboard.GetText
> > >
> > > Hope this helps,
> > > Brian Stenglein
> > > Clow Stamping Company
> > >
> > > --- In vantage@y..., Ed Kulbacki <efkcon01@y...>
> > > wrote:
> > > > I already had tried that once and it didn't
> pull
> > > the
> > > > data parameter into the program. It was blank,
> so
> > > I
> > > > figured it didn't work.
> > > >
> > > > Any other ideas or info?
> > > >
> > > > Ed
> > > >
> > > > --- Lonnie Drew <lonniedrew@c...> wrote:
> > > > > Ed,
> > > > >
> > > > > In Vantage help, search for 'VantageBasic
> > > > > Programmer's Reference'.
> > > > > Here's some text RELATED to your issue....
> > > > >
> > > > > "One property to which VB allows the user
> access
> > > is
> > > > > the window value,
> > > > > abbreviated as scrvalue, which is the value
> of
> > > the
> > > > > control as it
> > > > > appears on the window. For example, if the
> user
> > > is
> > > > > in Job Entry
> > > > > looking at Job number 10000, the scrvalue of
> the
> > > > > JobNum control is
> > > > > 10000.
> > > > >
> > > > > The syntax for accessing the window value of
> a
> > > > > control is this:
> > > > > {controlname.scrvalue}. The control name is
> > > usually
> > > > > defined by a
> > > > > table name and control name. For example,
> the
> > > value
> > > > > currently entered
> > > > > in the Job Number field on the initial job
> entry
> > > > > window is
> > > > > {jobhead.jobnum.scrvalue}.
> > > > >
> > > > > Obviously, you need to know the name of a
> > > control in
> > > > > order to refer
>
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
2
Can anyone tell me if it is possible to pass data which was
just entered on a VB form, which HAS NOT BEEN SAVED yet by
clicking on "OK", to a program executed with a button further
on down the form using the shellexec command? I am trying to
pass the data as a parameter to the program being executed.

Also, is it possible to pass data that was entered on the
screen just prior to going into a VB form as a parameter to
a shellexec command on the VB form?

Any documentation anywhere on something like this?

Any help would be greatly appreciated.

Ed Kulbacki
3
Ed,

In Vantage help, search for 'VantageBasic Programmer's Reference'.
Here's some text RELATED to your issue....

"One property to which VB allows the user access is the window value,
abbreviated as scrvalue, which is the value of the control as it
appears on the window. For example, if the user is in Job Entry
looking at Job number 10000, the scrvalue of the JobNum control is
10000.

The syntax for accessing the window value of a control is this:
{controlname.scrvalue}. The control name is usually defined by a
table name and control name. For example, the value currently entered
in the Job Number field on the initial job entry window is
{jobhead.jobnum.scrvalue}.

Obviously, you need to know the name of a control in order to refer
to its window value. You can see a complete list of all the
accessible controls on any window in Vantage by right-clicking any
blank area on that window"

There's also some examples in the Vantage\VBP directory.

Lonnie

--- In vantage@y..., efkcon01@y... wrote:
> Can anyone tell me if it is possible to pass data which was
> just entered on a VB form, which HAS NOT BEEN SAVED yet by
> clicking on "OK", to a program executed with a button further
> on down the form using the shellexec command? I am trying to
> pass the data as a parameter to the program being executed.
>
> Also, is it possible to pass data that was entered on the
> screen just prior to going into a VB form as a parameter to
> a shellexec command on the VB form?
>
> Any documentation anywhere on something like this?
>
> Any help would be greatly appreciated.
>
> Ed Kulbacki
4
I already had tried that once and it didn't pull the
data parameter into the program. It was blank, so I
figured it didn't work.

Any other ideas or info?

Ed

--- Lonnie Drew <lonniedrew@...> wrote:
> Ed,
>
> In Vantage help, search for 'VantageBasic
> Programmer's Reference'.
> Here's some text RELATED to your issue....
>
> "One property to which VB allows the user access is
> the window value,
> abbreviated as scrvalue, which is the value of the
> control as it
> appears on the window. For example, if the user is
> in Job Entry
> looking at Job number 10000, the scrvalue of the
> JobNum control is
> 10000.
>
> The syntax for accessing the window value of a
> control is this:
> {controlname.scrvalue}. The control name is usually
> defined by a
> table name and control name. For example, the value
> currently entered
> in the Job Number field on the initial job entry
> window is
> {jobhead.jobnum.scrvalue}.
>
> Obviously, you need to know the name of a control in
> order to refer
> to its window value. You can see a complete list of
> all the
> accessible controls on any window in Vantage by
> right-clicking any
> blank area on that window"
>
> There's also some examples in the Vantage\VBP
> directory.
>
> Lonnie
>
> --- In vantage@y..., efkcon01@y... wrote:
> > Can anyone tell me if it is possible to pass data
> which was
> > just entered on a VB form, which HAS NOT BEEN
> SAVED yet by
> > clicking on "OK", to a program executed with a
> button further
> > on down the form using the shellexec command? I
> am trying to
> > pass the data as a parameter to the program being
> executed.
> >
> > Also, is it possible to pass data that was entered
> on the
> > screen just prior to going into a VB form as a
> parameter to
> > a shellexec command on the VB form?
> >
> > Any documentation anywhere on something like this?
> >
> > Any help would be greatly appreciated.
> >
> > Ed Kulbacki
>
>


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
5
Ed,

I think you are talking about doing something similar to what I've
done. I launch a Visual Basic Program from the QuoteMtl VB Form and
I pass to it the Part Number from the screen before the VB Form by
using the following commands.

set _cliptext={QuoteMtl.PartNum.scrvalue}
shellexec w:\vantage\vbforms\material\material.exe

The first line puts the value of the PartNum field into the
clipboard. And obviously the second line launches by VB Program.
Then, when my Visual Basic Form Activates, it sets the focus in the
field for PartNum and basically pastes the text from Vantage into
that field. I am only doing this process for 1 field, I believe
there would be problems with trying to do it for multiple fields, but
I haven't tried it.

Private Sub Form_Activate()

txtVantPartNum.SetFocus

Screen.ActiveControl.SelText = Clipboard.GetText

Hope this helps,
Brian Stenglein
Clow Stamping Company

--- In vantage@y..., Ed Kulbacki <efkcon01@y...> wrote:
> I already had tried that once and it didn't pull the
> data parameter into the program. It was blank, so I
> figured it didn't work.
>
> Any other ideas or info?
>
> Ed
>
> --- Lonnie Drew <lonniedrew@c...> wrote:
> > Ed,
> >
> > In Vantage help, search for 'VantageBasic
> > Programmer's Reference'.
> > Here's some text RELATED to your issue....
> >
> > "One property to which VB allows the user access is
> > the window value,
> > abbreviated as scrvalue, which is the value of the
> > control as it
> > appears on the window. For example, if the user is
> > in Job Entry
> > looking at Job number 10000, the scrvalue of the
> > JobNum control is
> > 10000.
> >
> > The syntax for accessing the window value of a
> > control is this:
> > {controlname.scrvalue}. The control name is usually
> > defined by a
> > table name and control name. For example, the value
> > currently entered
> > in the Job Number field on the initial job entry
> > window is
> > {jobhead.jobnum.scrvalue}.
> >
> > Obviously, you need to know the name of a control in
> > order to refer
> > to its window value. You can see a complete list of
> > all the
> > accessible controls on any window in Vantage by
> > right-clicking any
> > blank area on that window"
> >
> > There's also some examples in the Vantage\VBP
> > directory.
> >
> > Lonnie
> >
> > --- In vantage@y..., efkcon01@y... wrote:
> > > Can anyone tell me if it is possible to pass data
> > which was
> > > just entered on a VB form, which HAS NOT BEEN
> > SAVED yet by
> > > clicking on "OK", to a program executed with a
> > button further
> > > on down the form using the shellexec command? I
> > am trying to
> > > pass the data as a parameter to the program being
> > executed.
> > >
> > > Also, is it possible to pass data that was entered
> > on the
> > > screen just prior to going into a VB form as a
> > parameter to
> > > a shellexec command on the VB form?
> > >
> > > Any documentation anywhere on something like this?
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Ed Kulbacki
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo!
Messenger
> http://phonecard.yahoo.com/
6
I just did this very thing the other day. I was trying to open a web page
from a VB form and pass it the OrderNum from the Job entry vbform. For some
reason the VB form wouldn't allow me to access the JobNum control(I have the
same problem with the OrderNum control on order entry, even though the
example in the Vantage Basic book lists Jobhead.JobNum.scrvalue as being a
valid control all I ever get is a blank). What I did was create a Progress
.p program that finds the JobNum based on the current row id. It will then
find the ordernum based on the jobnum in the jobprod table. It will then
paste it into the clipboard. From there I wrote a little VB(Visual not
Vantage) module that opens Internet Explorer and passes the OrderNum from
the clipboard. Not the prettiest situation but it works so I'm not going to
mess with it anymore. I just uploaded the .p program. Hope it helps.

Ed Giallombardo
Computer Technician
Major Industries, Inc.
7120 Stewart Ave.
Wausau, WI 54402
phone: 715-842-4616 ext. 322
email: egiallombardo@...

-----Original Message-----
From: Ed Kulbacki [mailto:efkcon01@...]
Sent: Tuesday, August 28, 2001 7:08 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: passing data in VB forms and shellexec


I already had tried that once and it didn't pull the
data parameter into the program. It was blank, so I
figured it didn't work.

Any other ideas or info?

Ed

--- Lonnie Drew <lonniedrew@...> wrote:
> Ed,
>
> In Vantage help, search for 'VantageBasic
> Programmer's Reference'.
> Here's some text RELATED to your issue....
>
> "One property to which VB allows the user access is
> the window value,
> abbreviated as scrvalue, which is the value of the
> control as it
> appears on the window. For example, if the user is
> in Job Entry
> looking at Job number 10000, the scrvalue of the
> JobNum control is
> 10000.
>
> The syntax for accessing the window value of a
> control is this:
> {controlname.scrvalue}. The control name is usually
> defined by a
> table name and control name. For example, the value
> currently entered
> in the Job Number field on the initial job entry
> window is
> {jobhead.jobnum.scrvalue}.
>
> Obviously, you need to know the name of a control in
> order to refer
> to its window value. You can see a complete list of
> all the
> accessible controls on any window in Vantage by
> right-clicking any
> blank area on that window"
>
> There's also some examples in the Vantage\VBP
> directory.
>
> Lonnie
>
> --- In vantage@y..., efkcon01@y... wrote:
> > Can anyone tell me if it is possible to pass data
> which was
> > just entered on a VB form, which HAS NOT BEEN
> SAVED yet by
> > clicking on "OK", to a program executed with a
> button further
> > on down the form using the shellexec command? I
> am trying to
> > pass the data as a parameter to the program being
> executed.
> >
> > Also, is it possible to pass data that was entered
> on the
> > screen just prior to going into a VB form as a
> parameter to
> > a shellexec command on the VB form?
> >
> > Any documentation anywhere on something like this?
> >
> > Any help would be greatly appreciated.
> >
> > Ed Kulbacki
>
>


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/ <http://phonecard.yahoo.com/>


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=210544.1579977.3132570.1261774/D=egroupweb/S=17050071
83:HM/A=776675/R=0/*http://ads.track-star.com/adspace.ts?ts=1;2;217;107_220_
105_264> Lose 20 lbs by November 5th

<http://us.adserver.yahoo.com/l?M=210544.1579977.3132570.1261774/D=egroupmai
l/S=1705007183:HM/A=776675/rand=873410484>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
7
Brian,

With the Visual Basic program, would it be possible
to pull in 3 or 4 pieces of data from the clipboard
as well as other data from elsewhere in the Vantage
system?

Can you send me more details or snapshots of what
you have done?

Ed

--- bstenglein@... wrote:
> Ed,
>
> I think you are talking about doing something
> similar to what I've
> done. I launch a Visual Basic Program from the
> QuoteMtl VB Form and
> I pass to it the Part Number from the screen before
> the VB Form by
> using the following commands.
>
> set _cliptext={QuoteMtl.PartNum.scrvalue}
> shellexec w:\vantage\vbforms\material\material.exe
>
> The first line puts the value of the PartNum field
> into the
> clipboard. And obviously the second line launches
> by VB Program.
> Then, when my Visual Basic Form Activates, it sets
> the focus in the
> field for PartNum and basically pastes the text from
> Vantage into
> that field. I am only doing this process for 1
> field, I believe
> there would be problems with trying to do it for
> multiple fields, but
> I haven't tried it.
>
> Private Sub Form_Activate()
>
> txtVantPartNum.SetFocus
>
> Screen.ActiveControl.SelText = Clipboard.GetText
>
> Hope this helps,
> Brian Stenglein
> Clow Stamping Company
>
> --- In vantage@y..., Ed Kulbacki <efkcon01@y...>
> wrote:
> > I already had tried that once and it didn't pull
> the
> > data parameter into the program. It was blank, so
> I
> > figured it didn't work.
> >
> > Any other ideas or info?
> >
> > Ed
> >
> > --- Lonnie Drew <lonniedrew@c...> wrote:
> > > Ed,
> > >
> > > In Vantage help, search for 'VantageBasic
> > > Programmer's Reference'.
> > > Here's some text RELATED to your issue....
> > >
> > > "One property to which VB allows the user access
> is
> > > the window value,
> > > abbreviated as scrvalue, which is the value of
> the
> > > control as it
> > > appears on the window. For example, if the user
> is
> > > in Job Entry
> > > looking at Job number 10000, the scrvalue of the
> > > JobNum control is
> > > 10000.
> > >
> > > The syntax for accessing the window value of a
> > > control is this:
> > > {controlname.scrvalue}. The control name is
> usually
> > > defined by a
> > > table name and control name. For example, the
> value
> > > currently entered
> > > in the Job Number field on the initial job entry
> > > window is
> > > {jobhead.jobnum.scrvalue}.
> > >
> > > Obviously, you need to know the name of a
> control in
> > > order to refer
> > > to its window value. You can see a complete list
> of
> > > all the
> > > accessible controls on any window in Vantage by
> > > right-clicking any
> > > blank area on that window"
> > >
> > > There's also some examples in the Vantage\VBP
> > > directory.
> > >
> > > Lonnie
> > >
> > > --- In vantage@y..., efkcon01@y... wrote:
> > > > Can anyone tell me if it is possible to pass
> data
> > > which was
> > > > just entered on a VB form, which HAS NOT BEEN
> > > SAVED yet by
> > > > clicking on "OK", to a program executed with a
> > > button further
> > > > on down the form using the shellexec command?
> I
> > > am trying to
> > > > pass the data as a parameter to the program
> being
> > > executed.
> > > >
> > > > Also, is it possible to pass data that was
> entered
> > > on the
> > > > screen just prior to going into a VB form as a
> > > parameter to
> > > > a shellexec command on the VB form?
> > > >
> > > > Any documentation anywhere on something like
> this?
> > > >
> > > > Any help would be greatly appreciated.
> > > >
> > > > Ed Kulbacki
> > >
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Make international calls for as low as $.04/minute
> with Yahoo!
> Messenger
> > http://phonecard.yahoo.com/
>
>


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
8
Ed,

I have only tried this technique with 1 piece of data, I don't konw
how you would make it work with more than that unless you set up
multiple buttons, on the Vantage Basic form, each copying a piece of
data to the clipboard, and I guess you could make multiple buttons on
the Visual basic program pasting the data into the appropriate
field. The limitation is that the Clipboard will only hold 1 item at
a time, but with a little more user input I think you could make it
work. I'm not sure how you would make it more automatic, but my
Visual Basic skills are somewhat limited and rusty to boot.

Brian Stenglein

--- In vantage@y..., Ed Kulbacki <efkcon01@y...> wrote:
> Brian,
>
> With the Visual Basic program, would it be possible
> to pull in 3 or 4 pieces of data from the clipboard
> as well as other data from elsewhere in the Vantage
> system?
>
> Can you send me more details or snapshots of what
> you have done?
>
> Ed
>
> --- bstenglein@c... wrote:
> > Ed,
> >
> > I think you are talking about doing something
> > similar to what I've
> > done. I launch a Visual Basic Program from the
> > QuoteMtl VB Form and
> > I pass to it the Part Number from the screen before
> > the VB Form by
> > using the following commands.
> >
> > set _cliptext={QuoteMtl.PartNum.scrvalue}
> > shellexec w:\vantage\vbforms\material\material.exe
> >
> > The first line puts the value of the PartNum field
> > into the
> > clipboard. And obviously the second line launches
> > by VB Program.
> > Then, when my Visual Basic Form Activates, it sets
> > the focus in the
> > field for PartNum and basically pastes the text from
> > Vantage into
> > that field. I am only doing this process for 1
> > field, I believe
> > there would be problems with trying to do it for
> > multiple fields, but
> > I haven't tried it.
> >
> > Private Sub Form_Activate()
> >
> > txtVantPartNum.SetFocus
> >
> > Screen.ActiveControl.SelText = Clipboard.GetText
> >
> > Hope this helps,
> > Brian Stenglein
> > Clow Stamping Company
> >
> > --- In vantage@y..., Ed Kulbacki <efkcon01@y...>
> > wrote:
> > > I already had tried that once and it didn't pull
> > the
> > > data parameter into the program. It was blank, so
> > I
> > > figured it didn't work.
> > >
> > > Any other ideas or info?
> > >
> > > Ed
> > >
> > > --- Lonnie Drew <lonniedrew@c...> wrote:
> > > > Ed,
> > > >
> > > > In Vantage help, search for 'VantageBasic
> > > > Programmer's Reference'.
> > > > Here's some text RELATED to your issue....
> > > >
> > > > "One property to which VB allows the user access
> > is
> > > > the window value,
> > > > abbreviated as scrvalue, which is the value of
> > the
> > > > control as it
> > > > appears on the window. For example, if the user
> > is
> > > > in Job Entry
> > > > looking at Job number 10000, the scrvalue of the
> > > > JobNum control is
> > > > 10000.
> > > >
> > > > The syntax for accessing the window value of a
> > > > control is this:
> > > > {controlname.scrvalue}. The control name is
> > usually
> > > > defined by a
> > > > table name and control name. For example, the
> > value
> > > > currently entered
> > > > in the Job Number field on the initial job entry
> > > > window is
> > > > {jobhead.jobnum.scrvalue}.
> > > >
> > > > Obviously, you need to know the name of a
> > control in
> > > > order to refer
> > > > to its window value. You can see a complete list
> > of
> > > > all the
> > > > accessible controls on any window in Vantage by
> > > > right-clicking any
> > > > blank area on that window"
> > > >
> > > > There's also some examples in the Vantage\VBP
> > > > directory.
> > > >
> > > > Lonnie
> > > >
> > > > --- In vantage@y..., efkcon01@y... wrote:
> > > > > Can anyone tell me if it is possible to pass
> > data
> > > > which was
> > > > > just entered on a VB form, which HAS NOT BEEN
> > > > SAVED yet by
> > > > > clicking on "OK", to a program executed with a
> > > > button further
> > > > > on down the form using the shellexec command?
> > I
> > > > am trying to
> > > > > pass the data as a parameter to the program
> > being
> > > > executed.
> > > > >
> > > > > Also, is it possible to pass data that was
> > entered
> > > > on the
> > > > > screen just prior to going into a VB form as a
> > > > parameter to
> > > > > a shellexec command on the VB form?
> > > > >
> > > > > Any documentation anywhere on something like
> > this?
> > > > >
> > > > > Any help would be greatly appreciated.
> > > > >
> > > > > Ed Kulbacki
> > > >
> > > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Make international calls for as low as $.04/minute
> > with Yahoo!
> > Messenger
> > > http://phonecard.yahoo.com/
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com
9
What you need to do for multiple fields is create a delimited clipboard
value which you put together on the VB form and then dissassemble in Visual
Basic.
Here's an example for the VB syntax(no spaces after the equals sign:

set _cliptext={QuoteHed.Reference.scrvalue}","{QuoteHed.Quoted.scrvalue}

Here's an example of the code in Visual Basic that would dissassemble the
clipboard text into the different fields:

Dim ClipText As String
Dim Reference As String
Dim Quoted As String
Dim pos As Integer
Dim i As Integer
Dim Word As String
Dim Ticker As Integer

ClipText = Clipboard.GetText
pos = 0
Ticker = 0

For i = 1 To Len(ClipText)
Char = Mid(ClipText, i, 1)

If Char = "," Then
Word = Mid(ClipText, pos + 1, i - (pos + 1))
pos = i
Ticker = Ticker + 1
Select Case Ticker:
Case 1:
Reference = Word
Case 2:
Quoted = Word
End Select
End If


Ed Giallombardo
Computer Technician
Major Industries, Inc.
7120 Stewart Ave.
Wausau, WI 54402
phone: 715-842-4616 ext. 322
email: egiallombardo@...

-----Original Message-----
From: bstenglein@... [mailto:bstenglein@...]
Sent: Tuesday, September 04, 2001 8:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: passing data in VB forms and shellexec


Ed,

I have only tried this technique with 1 piece of data, I don't konw
how you would make it work with more than that unless you set up
multiple buttons, on the Vantage Basic form, each copying a piece of
data to the clipboard, and I guess you could make multiple buttons on
the Visual basic program pasting the data into the appropriate
field. The limitation is that the Clipboard will only hold 1 item at
a time, but with a little more user input I think you could make it
work. I'm not sure how you would make it more automatic, but my
Visual Basic skills are somewhat limited and rusty to boot.

Brian Stenglein

--- In vantage@y..., Ed Kulbacki <efkcon01@y...> wrote:
> Brian,
>
> With the Visual Basic program, would it be possible
> to pull in 3 or 4 pieces of data from the clipboard
> as well as other data from elsewhere in the Vantage
> system?
>
> Can you send me more details or snapshots of what
> you have done?
>
> Ed
>
> --- bstenglein@c... wrote:
> > Ed,
> >
> > I think you are talking about doing something
> > similar to what I've
> > done. I launch a Visual Basic Program from the
> > QuoteMtl VB Form and
> > I pass to it the Part Number from the screen before
> > the VB Form by
> > using the following commands.
> >
> > set _cliptext={QuoteMtl.PartNum.scrvalue}
> > shellexec w:\vantage\vbforms\material\material.exe
> >
> > The first line puts the value of the PartNum field
> > into the
> > clipboard. And obviously the second line launches
> > by VB Program.
> > Then, when my Visual Basic Form Activates, it sets
> > the focus in the
> > field for PartNum and basically pastes the text from
> > Vantage into
> > that field. I am only doing this process for 1
> > field, I believe
> > there would be problems with trying to do it for
> > multiple fields, but
> > I haven't tried it.
> >
> > Private Sub Form_Activate()
> >
> > txtVantPartNum.SetFocus
> >
> > Screen.ActiveControl.SelText = Clipboard.GetText
> >
> > Hope this helps,
> > Brian Stenglein
> > Clow Stamping Company
> >
> > --- In vantage@y..., Ed Kulbacki <efkcon01@y...>
> > wrote:
> > > I already had tried that once and it didn't pull
> > the
> > > data parameter into the program. It was blank, so
> > I
> > > figured it didn't work.
> > >
> > > Any other ideas or info?
> > >
> > > Ed
> > >
> > > --- Lonnie Drew <lonniedrew@c...> wrote:
> > > > Ed,
> > > >
> > > > In Vantage help, search for 'VantageBasic
> > > > Programmer's Reference'.
> > > > Here's some text RELATED to your issue....
> > > >
> > > > "One property to which VB allows the user access
> > is
> > > > the window value,
> > > > abbreviated as scrvalue, which is the value of
> > the
> > > > control as it
> > > > appears on the window. For example, if the user
> > is
> > > > in Job Entry
> > > > looking at Job number 10000, the scrvalue of the
> > > > JobNum control is
> > > > 10000.
> > > >
> > > > The syntax for accessing the window value of a
> > > > control is this:
> > > > {controlname.scrvalue}. The control name is
> > usually
> > > > defined by a
> > > > table name and control name. For example, the
> > value
> > > > currently entered
> > > > in the Job Number field on the initial job entry
> > > > window is
> > > > {jobhead.jobnum.scrvalue}.
> > > >
> > > > Obviously, you need to know the name of a
> > control in
> > > > order to refer
> > > > to its window value. You can see a complete list
> > of
> > > > all the
> > > > accessible controls on any window in Vantage by
> > > > right-clicking any
> > > > blank area on that window"
> > > >
> > > > There's also some examples in the Vantage\VBP
> > > > directory.
> > > >
> > > > Lonnie
> > > >
> > > > --- In vantage@y..., efkcon01@y... wrote:
> > > > > Can anyone tell me if it is possible to pass
> > data
> > > > which was
> > > > > just entered on a VB form, which HAS NOT BEEN
> > > > SAVED yet by
> > > > > clicking on "OK", to a program executed with a
> > > > button further
> > > > > on down the form using the shellexec command?
> > I
> > > > am trying to
> > > > > pass the data as a parameter to the program
> > being
> > > > executed.
> > > > >
> > > > > Also, is it possible to pass data that was
> > entered
> > > > on the
> > > > > screen just prior to going into a VB form as a
> > > > parameter to
> > > > > a shellexec command on the VB form?
> > > > >
> > > > > Any documentation anywhere on something like
> > this?
> > > > >
> > > > > Any help would be greatly appreciated.
> > > > >
> > > > > Ed Kulbacki
> > > >
> > > >
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Make international calls for as low as $.04/minute
> > with Yahoo!
> > Messenger
> > > http://phonecard.yahoo.com/ <http://phonecard.yahoo.com/>
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com <http://im.yahoo.com>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=210544.1579876.3135161.1261774/D=egroupweb/S=17050071
83:HM/A=776675/R=0/*http://ads.track-star.com/adspace.ts?ts=1;2;217;107_220_
105_264> Lose 20 lbs by November 5th

<http://us.adserver.yahoo.com/l?M=210544.1579876.3135161.1261774/D=egroupmai
l/S=1705007183:HM/A=776675/rand=757628792>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
10
Using the new Split function in VB will make it easy to parse the
clipboard text.

Syntax

myArray = Split(expression[, delimiter[, limit[, compare]]])

You can hit F1 in VB to find an example.

And I like to use a delimiter which would never occur in the string
itself.

Jeff Lewis



[Non-text portions of this message have been removed]