1. Excel File Extension

Amir,I don't believe that Excel contains a mechanism for generating VBS code. This is because VBS is only a subset of VBA-VBA contains a number of features not supported by VBS. Obviously though, if you have written your VBA code so that it does not use any features not supported by VBS, you can simply copy and paste the code from the VBE to the VBscript editor.

The VBscript VBE can also read.bas source code text files written by the Excel VBE. Just right-click on a macro module in the VBscript VBE and select Import.Damon. MrExcel.com debuted on November 21, 1998.MrExcel.com provides examples of Formulas, Functions and Visual Basic proceduresfor illustration only, without warranty either expressed or implied, includingbut not limited to the implied warranties of merchantability and/or fitness fora particular purpose. The Formulas, Functions and Visual Basic procedures on thisweb site are provided 'as is' and we do not guarantee that they can be used in allsituations.This site contains affiliate links. Any affiliate commissions that weearn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.comrunning.

Excel File Extension

You can earn a commission for sales leads that you send to us by joining our.View our, and.Excel ® is a registered trademark of the Microsoft Corporation.MrExcel ® is a registered trademark of Tickling Keys, Inc.All contents © 1998 - 2019 MrExcel Publishing All rights reserved.