Good morning,
I've made the loop for the range, which is copied from one sheet to another. However I have no solution for trimming my code down, which looks like this:
Sub sunrise()
Dim i As Single
With Worksheets("7")
.UsedRange.Clear
.Range("a1").Value = "Latitude"
.Range("b1").Value = "...
@mansellan Having not yet read the question, I read the answer. As I started reading the question, I was thinking that somewhere you'd asked how many people might find your click-once packager useful. I thought the answer as "1". :)
So the MS-Access Version Control software I have been helping with is trying to make a quantum leap in to DevOps with the ability to build an AccessDB application in a GitLab Runner / Azure DevOps Agent / GitHub sort of CI\CD pipeline. QUESTION: Can Rubberduck testing be called somehow automatically from the command line?
If we had the automated build, could RubberDuck then be invoked to show all test cases passing?
We are just running access with command line switches to call a function that does magic and closes access. So it's not that it's fully "Headless" but it's automated.
I guess a better question is: Can RD testing be kicked off with a VBA command? Because there is already a function running. It just needs to pass to RD and somehow get the results of the test back.
The problem is that in a true headless scenario, there will be no user profile, no desktop, and all that extra baggage.
Office, however, can't work in that kind of environment. If you set it up to run on an Azure virtual machine, then that is not a problem.
since if it freezes or something, you can intervene by logging in and doing something or at least rebooting it.
to get unit tests to run headless, we need a VBA host that can support the scenario but even so, we'd need to be sure to hook all calls like MsgBox to avoid freezing. Since MS no longer licenses VBA SDK....
Good morning,
I've made the loop for the range, which is copied from one sheet to another. However I have no solution for trimming my code down, which looks like this:
Sub sunrise()
Dim i As Single
With Worksheets("7")
.UsedRange.Clear
.Range("a1").Value = "Latitude"
.Range("b1").Value = "...
VBA Rubberducking
VBA Rubberducking