Menu
I am developing a VBA application which is quite large. I want to use SVN for that application developing.
How can I split my modules from the Excel document and how to upload my modules separately to source control?
Please help me.
426
In The VBA Editor Add modules for each macro (Menu Insert/Module) copy each macros code into a module and save as a text file with control + E. Save into your git folder and use the normal git procedures to commit any changes. When you change the vba code re save (control+E) the module and update git as normal.
Run Macro When a Cell Changes (Method 1)Go to the VBA Editor (Alt + F11) and double-click the name of the spreadsheet that contains the cell that will change or just right-click the worksheet tab and click View Code.
After the ampersand (&) symbol, press the spacebar and get the VBA constant “vbNewLine.” After the constant “vbNewLine,” press one more time space bar and add the ampersand (&) symbol. After the second ampersand (&) symbol, type one more space character, and add the next line sentence in double quotes. We have done it.
Check out this excel addin https://github.com/hilkoc/vbaDeveloper .
It exports all your vba code automatically, as soon as you save your workbook. You can also easily import it again, when you open a workbook. It all work very nicely.
As a bonus, it comes with a code formatter that you can run within the vba editor, so you can format your code as you write.
70
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
