Hi Dale - I created a macro:
Sub ff() Shell "c:\program files\quotes plus\qp_disp32 mmm" End Sub This will open the chart with MMM as the symbol. I don't know how to pass a parameter with the hyperlink command though. Gary ----- Original Message ----- From: dalewarehime To: [email protected] Sent: Thursday, June 29, 2006 4:06 PM Subject: [quotes-plus] Re: Daily Market Report request 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] > [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/
