0 votes
in VBA by Beginner (123 points)
personal bas file
by Skilled (306 points)
BAS file is the exported module

If you right-click the module and selected "Export" then you can save the module (either it was Standard module or UserForm module or Class module) to any location you specify

And may be personal related to PERSONAL workbook where you can store your VBA codes.
by Beginner (123 points)
What does BAS stand for? what is its full form?
by Skilled (306 points)

BAS is a file extension for a source code file format used by BASIC (Beginners All-purpose Symbolic Instructional Code), an early programming language that is still among the simplest and most popular of programming languages.

1 Answer

0 votes
ago by Beginner (110 points)
Hi Sandeep.. good question. Your personal macro workbook file is named PERSONAL.XLSB and is stored in XLSTART. When EXCEL starts, it is opened as a hidden workbook and therefore makes any macros stored in it available to any open workbook during the session. BAS is the file extension for a source code file used in the BASIC programming language. When you export a module from the VBE, it will be stored as ModuleName.bas. So, if you export your personal macro workbook, it will be stored in the location of your choice as PERSONAL.BAS. You can then archive it for security or use it to import your personal macro workbook macros from one computer to another. This is my best answer to what I understand to be your question. I hope it helps. Good luck!

Welcome to wellsr Q&A
wellsr Q&A is the VBA and Python programming community that rewards you for learning how to code.

Earn free prizes for asking VBA and Python questions and for answering questions asked by others in our community.

What makes us different?
Our points system rewards you with a chance for free gifts as your contributions grow. The more points you earn, the better the prizes.

Getting Started

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.

Top Users Mar 2019
  1. YasserKhalil

    306 Points

  2. ParserMonster

    204 Points

  3. Alberto Semat

    186 Points

  4. danmcg

    127 Points

  5. Abdan

    124 Points

Prizes for March 2019
Terms and Conditions
1st place (1) 1-year MyExcelOnline Academy Membership
(2) My First Add-in Dev Pack & Course
(3) AutoMacro: VBA Code Generator (Developer)
(4) VBA Cheat Sheet Bundle
(5) $35 Amazon Gift Card
2nd place (1) My First Add-in Dev Pack & Course
(2) 101 Most Popular Excel Formulas E-Book
(3) VBA Cheat Sheet Bundle
(4) $25 Amazon Gift Card
3rd place (1) Mouse to Macro
(2) VBA Cheat Sheet Bundle
(3) $15 Amazon Gift Card