The Shell command is used to start another application. In this case,
it would appear that there is a named range called
GoogleEarthExecutable that contains the full file name of the Goggle
Earth program. The square brackets [ ] cause "GoogleEarthExecutable"
to be replace with the contents of that cell. Then, the CStr converts
that text into a string data format. The & " " & sfilename appends a
space followed by the contents of the variable named sfilename to the
exe file name. Finally, that whole string is passed to Shell which
executes it.
It is essentially the equivalent to
Shell "C:\Program Files\GoogleEarth.exe C:\SomeFileName.txt"
This starts the program C:\Program Files\GoogleEarth.exe and passes
the text "C:\SomeFileName.txt" to the program, which uses it in some
fashion unbeknownst to me.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
On Mon, 15 Mar 2010 10:49:01 -0700, Ayo
<(E-Mail Removed)> wrote:
>Shell (CStr([GoogleEarthExecutableLocation]) & " " & sfilename)
Similar Threads
