Gary: Thanks for the suggestion on the shell macro. It works. I am working on spreadsheet with a userform which loads the symbols from the 8080 file and open QP_disp32.exe with the selected chart.
Looking forward to use the method with the Daily Report shortly. Dale -- Dale M Warehime 3290 Charmil Drive Manchester, MD 21102 410-239-7343 ---- gary <[EMAIL PROTECTED]> wrote: > 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 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/
