Visual Basic Editor

N

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


--
 
D

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top