PSN-L Email List Message
Subject: Re: Quake data spreadsheet
From: Larry Conklin lconklin@............
Date: Sat, 24 Oct 2009 09:22:37 -0400
Below is a copy of the macro, cut & pasted right out of the spreadsheet.
The basic idea is to use the VBA Shell() function to call an external
program and pass the name of the file to be executed as a command line
argument. You could do this with most anthing, provided that the
program you pick expects command line arguments. Take note that some of
the lines in the code got folded to fit this e-mail. (Ie. DataFilePath
=.... , ExecutablePath = ... , ProcID = ...)
If you want to try it out I'd be happy to send you a copy of the whole
thing, along with a little file of "user notes" that I put together.
One little Winquake enhancement I'd love to see (hint, hint) is the
capability to take more than file name argument on the command line.
You can already select more than one file in the file open dialog box,
and if the files are compatable (same time parameters) they open
together, which allows direct comparison and manipulation of the two
files. If I use my spreadsheet to open more than one file, both open in
their own windows in Winquake, but any manipulations in one file window
do not affect the other.
' Pass a selected event file to Winquake for execution. The
' event file is selected by selecting the event file name in
' the spreadsheet.
Dim DataFilePath As String
Dim ExecutablePath As String
DataFilePath = Environ("WQPATH") & Range("Notes!D20").Value &
Left(ActiveCell.Value, 2) & "\"
ExecutablePath = Environ("WQPATH") & Range("Notes!D23").Value
ProcID = Shell(PathName:=ExecutablePath & " " & DataFilePath &
Stephen Hammond wrote:
> This sounds like something I would like to try, do you mind sharing the
> excel macro?
> Steve Hammond PSN Aptos, CA
Public Seismic Network Mailing List (PSN-L)
[ Top ]
[ Back ]
[ Home Page ]