Questions tagged [vba]
The vba tag has no summary.
29 questions
1 vote
4 answers
259 views
Tips for writing code that will be maintained by people who aren't familiar with good programming practices [closed]
I'm a mechanical engineer who works at a design build construction firm, and I've taught myself a lot more about coding and good programming practices since I started working just to automate some ...
- 49
-1 votes
2 answers
419 views
Excel/VBA to Application
In an engineering company, there are many engineers that edit in Excel/VBA Spreadsheets to perform some engineering calculations.They all do more or less similar things: calculate, manage engineering ...
- 115
4 votes
1 answer
351 views
PowerShell performance when running Excel macros
I run on a daily basis a set of VBA-rich Excel files. Most of them include MS Office application cross-talk, but also employ third-party applications and MySQL. Due to the fact of running those files ...
- 151
1 vote
1 answer
260 views
Data Matching In VBA - Best way to deal with dynamic data and user entry?
Background I am currently building this project with VBA, just to keep in the back of your mind when thinking about my question. Imagine 2 adjacent blocks, in Excel. The first block is made up of ...
- 27
0 votes
1 answer
271 views
Sequence matching problem is complicated, how can I break it down into easier smaller pieces?
I have two lists: 1: 1) A abc 2) A def 3) A ghi 4) B jkl 5) B mno 6) C fzy 7) C xxa 2: 1) vsf 2) jkl 3) fzy 4) xxa 5) xyz 6) mno 7) def 8) abc I am trying to match each of the continuous sequences ...
- 363
5 votes
1 answer
2k views
Block Scoped and Function Scoped Languages
I've noticed that some languages like C, C++, Java, Perl, and .NET Visual Basic have "block" scoping which means that a variable will only be defined within the specific code block it was declared in. ...
- 269
3 votes
1 answer
1k views
VBA Outlook: quickly find subfolder
I have the following structure in my Outlook Public Folders. -Public Folders --1001_RandomProject --1002_AnotherProject --1003_Yetanotherproject ... and so on, basically there's a couple of thousand(!...
- 143
2 votes
1 answer
540 views
Why would a program allow an object to be initialized when it doesn't support all methods/properties of the interface type it was defined as?
I'm under the impression that an object MUST support all methods/properties upon being initialized or else the program will create an error. However, if you see below I am defining 2 variables (doc ...
- 121