dim | Dynamic Information Model

I am trying to generate a table to record articles published each month. However, the months I work with different clients vary based on the campaign length. For example, Client A is on a six month contract from March to September. Client B is on a 12 month contract starting from February.

Rather than creating a bespoke list of the relevant months each time, I want to automatically generate the list based on campaign start and finish.

Here's a screenshot to illustrate how this might look:

Below is an example of expected output from the above, what I would like to achieve:

Currently, the only month that's generated is the last one. And it goes into A6 (I would have hoped A5, but I feel like I'm trying to speak a language using Google Translate, so...).

Here's the code I'm using:

I have this code which prints multiple tables

Sorry I don't show my variables or anything, tried to give information only pertaining to the questions. This 1 Sub is huge.

Currently my code allows a user to select multiple files, the files selected will be sorted in a specific format, then loaded into 2 different arrays. Currently loads Columns D:E into 1 array and Columns I:K into another array (from selected files QSResultFileWS, and returns those arrays to my destination FormattingWS. I'm still trying to learn arrays so if the methodology I used to do this isn't proper, be gentle.

The following code does everything I want: pulls email, saves attachments, extracts files EXCEPT save the original email to the folder fDest. I seem unable to see the solution.

This seems to be the problematic line as it won't save the email: "mi.SaveAs fDest2, olMSG"

My Question: What exactly does “compile-time” mean? I present my understanding below and where I am getting confused.

Compilation is the process that generates a single executable .exe file from the .vb file. There are several ways to do this, for example by using the VBC.EXE command from the developer command window or MSDOS. The way I understand “compile-time” is that it is time when such a command gets executed and the exe file is generated. The following are the what I find confusing:

1. When I write Dim i = 5, the compiler infers or “knows” that the variable “i” is an integer.
2. If I want to print an integer or a string using the Writeline method of the console class then the compiler automatically determines which overloaded version it should call. So in this case also the compiler “knows” – this is also known as compile-time polymorphism.

My confusion: Since in both the above cases the compiler infers or knows the type of variable or the version of the overloaded method to call just after we have finished typing the sentence, is this also called compile-time? We have not given any sort of compilation command here.

1. Another confusion on the definition of compile-time refers to the case when we explicitly define overloaded methods. In the case of the writeline method, we know from the pop-up given by intellisense that immediately after we have finished typing the sentence the version with the correct signature is called. Now, when we define overloaded methods does the compiler know which version to call when we call the function (depending on signature) somewhere in the program right after we have finished typing the code? Or does the compiler know this after the exe file has been generated? This is a case of compile-time polymorphism. But then which time or which step is the “compile-time”?

I have a list (dput() below) that has 4 datasets.I also have a variable called 'u' with 4 characters. I have made a video here which explains what I want and a spreadsheet is here.

The spreadsheet is not exactly how my data looks like but i am using it just as an example. My original list has 4 datasets but the spreadsheet has 3 datasets.

Essentially i have some characters(A,B,C,D) and i want to find the proportions of times each character occurs in each column of 3 groups of datasets.(Check video, its hard to explain by typing it out)

I have been trying to sort the Column values from A to Z which are populated in the List Box.

I have tried with the following but it does not adjust it. Any help will be appreciated.

How do I get the object type so I can directly cast to it? This is the ideal method I would like to execute:

I've created a simple VBA interface to connect Excel to a MySQL DB. The VBA part acts as a preview of data for the user to choose what item he wants to import to the Excel sheet.

Until now I've work with a very complete set of data, but I got to a Table which (because of the nature of the items) some fields are NULL.

Now every time I try to check the values in the VBA I get the Run-time error 13 Type mismatch in the listview component. At first I though it was a field with DECIMAL typing, but after changing it to a DOUBLE (for testing) the problem persisted, and it was until I notice that if only checks columns with no NULL value, the problem disappears. Off course I can't omit this values.

I tried some .Tostring functions but with no success. And I failed to implement a IF to check for NULL in the obj.

This is my code: