You're probably confusing VBScript and VBA. Both are derivatives of Visual
Basic. VBA is always stored within a host document like an Excel workbook or
a Word document. VBScript is stored in simple text files with a 'vbs'
extension. VBScript runs outside of any application (other than the VBS
interpreter).
By the way, you need post only in one group.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
"tishoo" wrote in message
...
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