Bing: VBA Variable Types

Newest 'vba' Questions - Stack Overflow

Wed, 08 Apr 2026 22:28:00 GMT

Visual Basic for Applications (VBA) is an event-driven programming language which was first introduced by Microsoft in 1993 to give Excel 5.0 a more robust object-oriented language for writing macros and automating the use of Excel.

VBA Run-time error '-2147467259 (80004005) - Stack Overflow

Tue, 07 Apr 2026 18:54:00 GMT

I am trying to connect to mysql using Excel VBA, I am using Excel 2013. I am new to VB, so i followed this example: Inserting Data Into MySQL From Excel Using VBA Here is my connection code:

第二课：Excel 中的 VBA：什么是 Visual Basic for Applications，如何使用

Tue, 17 Mar 2026 16:13:00 GMT

VBA 是一种高级语言，您可以使用它来使 excel 屈服于您所有强大的意志。 VBA 实际上是 Visual Basic 6.0 BASIC 的一个子集，代表 B eginners A ll-Purpose S ymbolic I nstruction Code 。为什么选择 VBA？ VBA 使您能够使用类似英语的语句来编写创建各种应用程序的指令。

'vba' tag wiki - Stack Overflow

Wed, 08 Apr 2026 09:28:00 GMT

VBA 7 was released in 2010 to address the new 64-bit version of Microsoft Office, which shipped in 2010. There are several important changes made to VBA 7 that make it different from VBA 6, namely compatibility with both 32 and 64-bit versions of Office. Applications using VBA 7 must address both backwards compatibility and 64-bit-safe issues.

Parsing JSON in Excel VBA - Stack Overflow

Thu, 09 Apr 2026 05:23:00 GMT

87 I have the same issue as in Excel VBA: Parsed JSON Object Loop but cannot find any solution. My JSON has nested objects so suggested solution like VBJSON and vba-json do not work for me. I also fixed one of them to work properly but the result was a call stack overflow because of to many recursion of the doProcess function.

What is the equivalent of "!=" in Excel VBA? - Stack Overflow

Wed, 08 Apr 2026 18:10:00 GMT

Because of that, getting the length in VBA is fast -- it's just reading an integer from memory -- and is slow in Java -- you need to iterate through the string. @LimaNightHawk far more efficient? Can you elaborate on that please? I guess that most modern compilers would catch the pattern <> "" and produce the same p-code as Len(str).

Find last used cell in Excel VBA - Stack Overflow

Wed, 08 Apr 2026 18:32:00 GMT

xlUp Leveraged vba method xlUp which was very fast, but skipped any rows that were hidden and only operated on one column. FIND VBA method that used Excel's APPLICATION method of find which searched for anything in cell formula. Previously this was what I considered the best option as it was fast and reliable, but modified user's settings.

Get list of Excel files in a folder using VBA - Stack Overflow

Tue, 07 Apr 2026 15:27:00 GMT

Filepath = "D:\Personal\" For Each i in FileArray Workbooks.Open(Filepath+i) Next I had a look at this, however, I wasn't able to open the files cause it stored the names in Variant format. In short, how can I use VBA to get a list of Excel filenames in a specific folder?

How to insert a column in Excel using VBA? - Stack Overflow

Wed, 08 Apr 2026 04:56:00 GMT

Sheet1.Range("A:A").EntireColumn.Insert Shift:=xlToRight while inserting a new row or column make sure to refer to the entire row or column. Check if there are any marge cells at the right of column A. That can possibly be causing the problem.

Automating Edge Browser using VBA without downloading Selenium

Wed, 08 Apr 2026 21:09:00 GMT

The advantage of this method is that it allows VBA to interact directly with Edge without IE mode and also with Chrome. Automate Chrome / Edge using VBA via CDP - Code Project The article above also includes an example file which you can download and explore the method.