Hey everyone
Good morning
I use Rubber duck VBA Add In
So I test all logical code easily (automatic testing by code)
However I am struggling to test UI stuff without changing the actual program status
I don’t want my test to create changes in the production or design environments
Can anyone help me in this matter?
Hey everyone
Good morning
I use Rubber duck VBA Add In
So I test all logical code easily (automatic testing by code)
However I am struggling to test UI stuff without changing the actual program status
I don’t want my test to create changes in the production or design environments
Can anyone help me in this matter?
Can I use my remote desktop while another user uses his own account on a shared computer? Both of us have separate account
I want to use my account with exact files that on the computer exactly like the idea of remote desktop
However remote desktop itself doesn’t allow me to do such a thing
Hey everyone
I use VBA since I work with Microsoft office often
Is it real that VBA is very old and not useful anymore? Multiple times on the internet or when I ask AI
I find the answer that VBA is not the right choice for me
To me I see many powerful stuff like
Classes
Unit tests
Mocks and fakes (didn’t try those)
So I don’t understand the negative opinions about it
However VBA is the only language I tried in depth other languages I tried were either just for the course or to complete simple task nothing deeper than that
Is learning VBA is bad decision? Or is it reasonable one?
I noticed many of the useful major concepts are transferable to any language like
Code architecture
Auto Testing
Data types and structures
Etc
Hey everyone
I am using a class module to create a form instant enforcing my common logic across all forms including events triggered behavior
Now I want the form to record time open and time close when I tried to include this logic in my form this part doesn’t work however other events fire just fine
I instantiate the class in the declaration area at the same line I create new class like this
Dim Form as New FormCM
In the desired form in on load event I pass some parameters to the class and that is it
Can any one tell me why the on open event doesn’t fire in my case?
How can u guys keep your excitement and love for coding
I feel like the interest I had in the beginning is getting weaker yes I listen to and watch many coding related content videos however when it comes to actually code it is starting to get dull even though I have not been coding that long so I am curious how can I keep coding a rich experience ?
Do u like coding or are you learning it out of pure need?
Hello I am a self taught programmer I have not been coding for long and I am learning concepts bit by bit for now I am using VBA since I use Microsoft a lot can you please advise me on how to practically document my code without overwhelming my self
I am solo programmer however I want to make it possible for my projects to be picked up after me
I am programming during my day job to make tools for the work so it is kind of side task to create those tools I can’t maintain very detailed documentations
Hey everyone
I know this is kind of basic question but I didn’t find a satisfying answer during my search
I am not system administrator and I won’t be all I care about is daily task automation I want to make my work nice and easy or at least systematic and controllable so is power shell the right tool for me? Or should I just drop it?
If it was can you please help me on how to learn it all what I could find on the internet specific to active directory application or too general and simple examples explaining techniques Without context I find my self spending hours only to learn that I memoized syntax but have absolutely no idea how to use it in my life
Hey everyone
I come from non IT major but I use MS ACCESS to structure my workflows in my company
(Currently most of the things are low tech anyway) they are planning and working toward ERP solution
I want real and honest feedback from you guys is this ERP will make my solutions and applications useless? Or is it a matter of some changes and improvements then I would be able to use them?
I am trying to apply and learn programming as I go in my projects I tried
Unit testing
SOR Principle (did not understand how to apply it fully yet)
I used everything including classes modules custom functions and routines everything
I started learning because i wanted to make my life easier and now I feel like my efforts will become insignificant which is making me feel heavy to do the stuff I need to do
Please advise I have ton of work to do including refactoring and testing old code while I feel it won’t matter after few months please give me your honest feedback