Free-standing macros

Can a macro exist and run on its own outside of a spreadsheet? I wrote a
program that I'd like to run from, say, my Desktop rather than opening a
spreadsheet and clicking a button. Any ideas?

Thanks, Matthew

Excel macros can only run in Excel. You might be able to convert your
code to a VBscript routine: all depends on what it does....

Tim.


"Pflugs" <Pflugs@discussions.microsoft.com> wrote in message
news:5C0DD83D-03E9-44E1-86AF-7EC250655FA9@microsoft.com...
> Can a macro exist and run on its own outside of a spreadsheet? I
> wrote a
> program that I'd like to run from, say, my Desktop rather than
> opening a
> spreadsheet and clicking a button. Any ideas?
>
> Thanks, Matthew
>

You should be able to do anything from VBScript, but it will require opening
an instance of Excel. Once you have a reference to an Excel object, you will
have the same options.

Here is a very trivial example that should be saved as a .vbs file and then
just launched

Dim xlApp

Set xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.Add
MsgBox xlApp.ActiveWorkbook.Name
xlApp.Quit
Set xlApp = Nothing


--
HTH

Bob Phillips

"Pflugs" <Pflugs@discussions.microsoft.com> wrote in message
news:5C0DD83D-03E9-44E1-86AF-7EC250655FA9@microsoft.com...
> Can a macro exist and run on its own outside of a spreadsheet? I wrote a
> program that I'd like to run from, say, my Desktop rather than opening a
> spreadsheet and clicking a button. Any ideas?
>
> Thanks, Matthew
>