| |

VerySource

 Forgot password?
 Register
Search
View: 2979|Reply: 15

How to compile and package VB code in Excel?

[Copy link]

2

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-1-7 20:00:01
| Show all posts |Read mode
How to compile and package VB code in Excel?
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-7-22 07:15:01
| Show all posts
Can't compile and package, but I can tell you the answer to another post-how to add a password lock to the VBA source code?
In the VBA programming interface, you can see a "Project" VBAProject properties window, right-click it (such as: VBAProject (Book1)), click Properties, click Protection, there is a setting for locking the project and viewing the password. You can click Set up here.

In this way, when you give someone an EXCEL program, they cannot open this source code area without a password, and your program is protected.
Reply

Use magic Report

0

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-8-1 14:00:01
| Show all posts
There is no way to compile and pack, unlike VB, because it is dependent on the excel file.
Reply

Use magic Report

0

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-8-8 13:00:01
| Show all posts
Used to package with vb, if you need this information, please go to the forum excelhome or office elite club
Reply

Use magic Report

0

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-8-16 23:15:01
| Show all posts
Friendly Bangding!
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-20 12:30:01
| Show all posts
1. Compile:
feasible. There is an edit menu in the VBA project, but this is not compiled into a binary file, but to help you see if there are errors in the code.
The way I want to protect is to add a password to the project, properties, and there. But to tell you the truth, it's easy to crack.
At present, I have not encountered any EXCEL VBA files that cannot be cracked.

2. Release:
I. Add an auto_run method to your VBA. The method name can't remember, but it must start with AUTO.
This is equivalent to the MAIN function.
I. Save your XLS as XLA.
II. Copy this XLA to the ADDIN directory of other users' EXCEL, and other users will open all their own EXCEL
Automatically load the AUTO_RUN method of your VBA, thus...

3. Other
If your VBA is really valuable, convert it to VB, it is safe after compilation! !
Otherwise, open source your VBA, the world needs open source.
Reply

Use magic Report

0

Threads

5

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-8-20 12:45:01
| Show all posts
up
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-20 13:15:01
| Show all posts
This world needs open source
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-22 15:30:01
| Show all posts
Open source your VBA, the world needs open source. Liked
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-22 17:45:01
| Show all posts
Can't package and compile at present
He relies on EXCEl files, unless excel files can also be packaged and compiled into executable programs, but it is currently impossible!
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list