Comments (12)
VBScript
yo!
http://stackoverflow.com/a/31186714/1138354
So, have everything in the src
folder with this buildProject.vbs
file and 🎉
from vba-ide-code-export.
Can you use .NET libraries from vb.script? I am wondering how we could inject the CustomUI.xml into the workbook in a vb.script environment.
from vba-ide-code-export.
I like this. This is how I do it on some other projects. The Base Path
property can be set to "src"
in the CodeExport.config.json
file to achieve this.
As for the build, no I haven't. I am still experimenting with different things. For another project, my workflow is, for development, I just open the workbook and import the VBA code. Then when I want to release a new version I do two things:
- I have a list of tasks to do to update the workbook (I have a version number and date cell which gets changed each version). I then commit this change to the repo. I haven't automated this yet.
- I open the workbook again, import the VBA code, then run a macro I named
PrepareForUser
which automatically sets necessary worksheet and workbook protection and then prompts me to set the VBA Project password (because this can't be automated, and I will forget).
I'm not sure how much of this would be useful for this project. I thought at the moment, just opening the template and then running Import
was sufficient (As described in the build instructions in the README).
What do you think?
from vba-ide-code-export.
I tried before with a PowerShell script file so all you have to do is run one file but it was ugly and I discovered that if you didn't have the right permissions [like if you're in a corporate environment] then the script is useless so I scrapped it pretty early on.
Looking at it now it's a pretty crude script actually.
This is the thing, I want this to be as painless as possible for prospective users to install and go, there's enough fiddling around with VCS' and doing the actual coding so this shouldn't be a barrier.
from vba-ide-code-export.
Yea, same, that's why I think not having to build the add-in at all is the way to go for the user. Just go to the download link, grab it and go. That's also why I'd like to implement issue #28 at some point.
Wow, I really like how simple it is to use Excel from PowerShell (I've never touched powershell before). What part couldn't be used in the corporate env?
from vba-ide-code-export.
You need to be admin to run a PS script off of the network/local storage I think, the thing was if you copy pasta the script into PowerShell ISE
you could run it, I think, can't recall exactly.
from vba-ide-code-export.
Oh yes, I remember when I took that PowerShell BS to the knee once. Haha. Well you could make the same script in C# (or VB.NET). In fact, if you wanted to take it further you could mirror the functionality of the Excel Add-In in a .NET command line tool so that you could do your importing and exporting from the command line. That was my intention for effoff but maybe that should just be a part of CodeExport and have both programs in the same repo.
from vba-ide-code-export.
Hmmm, how would effoff
be installed by the user? Would it go in the project folder? Do we make an organisation for the two to go under?? I don't know mate 🤔
from vba-ide-code-export.
All good ideas. I like the installation method, since I can't figure out how to create a standalone executable.
from vba-ide-code-export.
Good point, I do not know 😕
Why isn't there one thing that does all the things, gah!!
from vba-ide-code-export.
Haha, don't fret, give this a try: https://github.com/mattpalermo/effoff/releases/tag/v0.1.1
from vba-ide-code-export.
Resolved with #58
from vba-ide-code-export.
Related Issues (20)
- Syntax error in JSON configuration will raise an error
- Cannot run import twice in a row HOT 4
- Code "formatter" to fix whitespace issues
- Ribbon UI HOT 1
- CustomUI.xml (Ribbon UI) injection HOT 5
- Command line interface HOT 3
- Store Excel workbooks as Unpacked stack of XML files HOT 8
- README Improvements HOT 4
- Keep a changelog HOT 7
- Test and example workbooks HOT 4
- Build a wiki HOT 6
- Set VBAProject Name on Make Config File HOT 2
- Recommend using .gitattributes, .editorconfig and .gitignore files HOT 6
- XML to Excel
- `Add References` clearly detailed in the code HOT 1
- Deletion of macros' components after export of code HOT 6
- Installer is missing HOT 5
- File type check before Excel to XML
- Error 57101 - Can't remove default reference
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from vba-ide-code-export.