Questions tagged [vba]
The vba tag has no summary.
29 questions
1
vote
4
answers
260
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
0
votes
0
answers
141
views
Securely Handling Session Keys in Excel for API Authentication
I'm working on an Excel tool that needs to synchronize with a CRM via its API. The CRM's API authentication process involves logging in with a username and password, after which a session key is ...
-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
-2
votes
1
answer
134
views
Trouble Designing Programs in VBA
I am new to VBA and am struggling with overall program design:
Toy Example
Input: Spreadsheet with 20000 rows and 50 columns. Also, order of rows matters.
Task: Create 3 different reports on a new ...
- 19
4
votes
1
answer
352
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
2
votes
4
answers
584
views
Conditional vs Logical Testing
I would like to get your code thought and views on using conditional vs logical testing.
For example:
To test the conditions of truthness of all of the following variables, their currect status is ...
- 135
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
-2
votes
1
answer
93
views
Strategy for VLOOKUP in VBA
I need to fill a Products table in file A with their manufacturing costs that are in another Costs table in file B.
Currently, I read Products and Costs tables into their respective arrays and for ...
0
votes
1
answer
272
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
2
votes
1
answer
487
views
What are the key concepts in CPM/Gantt Chart algorithms?
having a bit of trouble getting started with this problem, and not much luck googling solutions.
I can't use MS Project to display gantt charts, so am wanting to use VBA to draw a pretty gantt chart ...
- 155
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
2
votes
2
answers
4k
views
Can I really make python work with VBA
I'm a heavy VBA user that when has the chance to do a little project in python it's like going from hell to haven when it comes to programming itself. Still, I know that my users want reports in excel ...
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
9
votes
5
answers
934
views
How to refer to ByRef and ByVal in a dropdown label? [closed]
The MSDN page on ByRef and ByVal keywords isn't very helpful; unless I somehow skipped it, they're simply being referred to as "keywords" everywhere.
One of the main contributors of the Rubberduck ...
- 1,720
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