Python script and Pipeline configuration file to extract VBA source files from MS Office files and commit/push them to a Git repository. It helps you manage your MS Office files with VBA macros on Azure DevOps.
- Microsoft Azure DevOps Service
- Add the azure-pipelines-extract-vba.yml to your Git repository.
- Commit and push your local repository to the Azure DevOps Server.
- On the Azure DevOps Server, go to the Pipelines and create new pipeline for your repository.
- At the Configure your pipeline, select the Existing Azure Pipelines YAML file, and then specify the azure-pipelines-extract-vba.yml added your Git repository as a configuration file.
- When you pushed your change to your Git repository on Azure DevOps,
the Pipeline will run and then extract VBA source files into the
/vba-src
directory.