"John 3:16" <bob***@tricoequipment.com> wrote in message
news:%23AERTG4vFHA.2728@TK2MSFTNGP14.phx.gbl...
> Is there a way to launch QA and tell it to open a stored procedure to
> edit...
> I know you can do this from within QA after it opens but...
>
> I have an app that I use to stay organized.
> I associate all related correspondece, contact info and files
> to the Contact & project.
>
> While working with a contact I can double click any associated
> file (.xls, .doc, .mdb, etc... ) and open it.
>
> I'd like to do the same with stored procs used in a given project.
> I'd like to write code that shells to the console to open QA and load
> an sp to edit.
>
> Example: For spreadsheets I get the filename & path and open excel, then
> the target file..
>
> Case ".xls": y = "C:\Program Files\Microsoft Office\Office\EXCEL.EXE " _
>                & Path & "\" & FileName & [Type]
>
> x = Shell(y, vbMaximizedFocus)
> (note: [Type] is simply the extension .xls )
>
> y would =
> C:\Program Files\Microsoft Office\Office\EXCEL.EXE
> E:\Common\~Mission\Mailers\Batches\AgingReports\Aging.Equipment.Report.jp.example.xls
>
> I would like to create a similiar string to open QA and load an sp to view
> / edit.
>
> any help with this would be much apprecaited.
> thanks in advance,
> bob mcclellan
>