View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Stand alone VBA script files

Note: A .bas file cannot be run as is, but must first be imported into an
appropriate host document (like an Excel workbook).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gary''s Student" wrote in message
...
Use .bas files

Using Excel VBA editor, create a script, then export it to a standalone
file
(.bas)
--
Gary's Student


"tishoo" wrote:

Question: Is it possible to have a standalone VBA script file that Excel
can
open, or does the VBA have to be written into an Excel document? If so
how
is it done?

Ta
T