Gary:
Thanks again.
That works with the run command and with a batch file. But
unfortunatly I am trying to make a hyperlink in Excel and it just
don't work,
The following is my code:
Sub TestHyperLink()
Dim DisplayText As String
Cells(2, 2).Select
DisplayText = "Click to Start QP Charts Open With Symbol"
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"C:\Program Files\Quotes Plus\qp_Disp32.exe" + " " +Cells
(1, 1), TextToDisplay:=DisplayText
Cells(4, 2).Select
DisplayText = "Click to Start QP Charts"
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"C:\Program Files\Quotes Plus\qp_Disp32.exe",
TextToDisplay:=DisplayText
End Sub
The first causes an error message stating the file can not be found.
The second open QP charts but of course without a symbol
The problem here is that hyperlink already requires the quotes, but
apparently throws them away.
Since this now appears to be an Excel VBA problem I am going to post
this on a VBA message list to see if someone on their can get me
going.
Dale
--- In [email protected], "gary" <[EMAIL PROTECTED]> wrote:
>
> Dale -
>
> Try this
>
> "C:\Program Files\Quotes Plus\QP_disp32.exe" jnj
>
> The spaces in the folder name are the problem.
>
> Put quotes around the fully qualified proigram name, and the
symbol outside of the quotes.
>
> Gary
>
>
> ----- Original Message -----
> From: dalewarehime
> To: [email protected]
> Sent: Thursday, June 29, 2006 12:16 PM
> Subject: [quotes-plus] Re: Daily Market Report request
>
>
> Gary:
>
> I am using QP 3.1 on XP SP2.
>
> "qp_disp32 jnj" does not work
>
> "C:\Program Files\Quotes Plus\QP_disp32.exe jnj" does not work.
>
> I don't know what I am missing here. QP_disp32 jnj seems to be
> missing .exe, but either way it can't find the file. Tried it
from
> the run command using Start buttom.
>
> I am not being difficult here but the program sure is.
>
> Dale
>
> --- In [email protected], "gary" <gary@> wrote:
> >
> > Hi Dale
> >
> > It's simple:
> >
> > qp_disp32 jnj
> >
> > this will open the chart program with symbol jnj displayed.
> >
> > That is the only parameter, you can pass one symbol on the
command
> line
> >
> >
> > Best regards,
> >
> > Gary
> >
> >
> > ----- Original Message -----
> > From: dalewarehime
> > To: [email protected]
> > Sent: Thursday, June 29, 2006 10:35 AM
> > Subject: [quotes-plus] Re: Daily Market Report request
> >
> >
> > Gary:
> >
> > Thanks for the reply on the HTML version of the report. It
will
> be a
> > much more usable report.
> >
> > The other question in my previous message concerning adding
> > parameters to the command line for starting QP Charts remains
> > unanswered. I'll try again.
> >
> > I am trying to open QP_disp32.exe from an Excel macro. The
> following
> > works to open the program but with the last symbol used and
the
> > last .lst file
> >
> > qp_disp32.exe
> >
> > does the program allow me to open charts by specifing a symbol
> > and/or a .lst file.
> >
> > This is done in Stock Picker Pro.
> >
> > Gary, I am not asking for a change in the program, only a
> > clarification on the capibilities of the program.
> >
> > Thanks again for your assistance
> >
> > Dale
> >
> > --- In [email protected], "gary" <gary@> wrote:
> > >
> > > Hi Dale -
> > >
> > > I can add an html version of the report, it won't be for
> another
> > month or so.
> > >
> > > Best regards,
> > >
> > > Gary
> > >
> > >
> >
> > > The other problem that I have in using this and indeed in
> using
> > > Excel in general is the need to effectively use a hyperlink
to
> > > QP_disp32.exe by opening the charts with a specific symbol
or
> a
> > list
> > > of symbols. Is there way such as "QP_disp32.exe /S bbt" that
> > would
> > > open the chart program displaying BBT Corp.
> > >
> > > Thanks for reviewing these requests.
> > >
> > > Dale
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Check out the new improvements in Yahoo! Groups email.
http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/quotes-plus/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
