0 votes
in VBA by Beginner (29 points)
personal bas file
by Expert (892 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 (29 points)
What does BAS stand for? what is its full form?
by Expert (892 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
by Beginner (56 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.

Getting Started
VBA Cheat Sheets (On Sale Now)

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

Looking for something else? Hire our professional VBA Help, instead.

What makes us different?
Our points system rewards you with a chance for free gifts based on the quality of your questions and answers. All you have to do is post and you could get rewarded, like these members:

ParserMonster $25 Amazon Gift Card
Hightree $10 Amazon Gift Card
Thales1 $10 Amazon Gift Card
runfunke $10 Amazon Gift Card
coolag $10 Amazon Gift Card
Siew Hun $10 Amazon Gift Card

So, why don't you join us? It really is an encouraging way to motivate members in our VBA and Python community.


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