About 60 results
Open links in new tab
  1. Excel 的 VBA 现在还算是办公利器吗? - 知乎

    先说结论,VBA依旧是办公利器。以我的个人经历而言,在BCG做过三年咨询顾问,写了上万行的VBA程序,每个项目一千至几千行程序不等。最后将Excel用成了中控界面,类似EMACS,在Excel可以随 …

  2. find - vba-excel meaning of <> (angled brackets or greater-than and ...

    Jun 30, 2011 · I am working with find functions in VBA Excel, so when I ran into problems I pulled some example code from the help provided in Excel. I took their code that illustrates a basic find function …

  3. Newest 'vba' Questions - Stack Overflow

    2 days ago · 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 …

  4. Excel VBA 初学者教程:3 天学会

    这个面向初学者的 Excel VBA 教程涵盖了学习 VBA Excel 和 VBA 基础知识的深入课程。此 Visual Basic for Applications Excel 教程涵盖了初学者的 VBA 的所有基础知识和高级概念。 什么是 VBA? VBA 代 …

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

    Jul 1, 2015 · 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 …

  6. 第二课:Excel 中的 VBA:什么是 Visual Basic for Applications,如何使用

    VBA 是一种高级语言,您可以使用它来使 excel 屈服于您所有强大的意志。 VBA 实际上是 Visual Basic 6.0 BASIC 的一个子集,代表 B eginners A ll-Purpose S ymbolic I nstruction Code 。 为什么选择 …

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

    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 …

  8. Properly Handling Errors in VBA (Excel) - Stack Overflow

    Properly Handling Errors in VBA (Excel) Ask Question Asked 14 years, 11 months ago Modified 3 years, 11 months ago

  9. excel - Creating an Array from a Range in VBA - Stack Overflow

    Jun 8, 2016 · Creating an Array from a Range in VBA Asked 9 years, 10 months ago Modified 2 years, 1 month ago Viewed 453k times

  10. Parsing JSON in Excel VBA - Stack Overflow

    Jul 8, 2011 · 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 …