Visual Basic Editor

[NealUK]

Just a quickie.
Can the Visual Basic Editor, that i can access via Excel2000, be used on its
own, or must i have a spreadsheet open?
Many thanks
Neal


--

 

[Dave Peterson]

VBA code lives in workbooks and workbooks have to be open to access the code.

But you could hide the workbook (window|Hide) or you could make the workbook an
addin (.xla).

But if you're asking if you can use the code without excel running, then the
answer is no.

You may want to look into another programming language that can create
executables.

 

[Murtaza]

how can i create a workbook an addin that should ask its own arguments?

 

[Dave Peterson]

You can save any old workbook as an addin by File|SaveAs. There's an option
under the "Save As Type" for "Microsoft Excel Addin (*.xla)"

But you'll have to provide an interface to the macros--either adding options to
existing toolbars or making a new one.

John Walkenbach has some nice code that you could use at:
http://j-walk.com/ss/excel/tips/tip53.htm
(It's his Menumaker program.)

I don't understand the part about "should ask its own arguments" though.