嵌入式宏与VBA [英] Embedded Macros Vs VBA

问题描述

假设有人合理地写了两篇Macros& VBA使得学习的简易性无关紧要，同时也认识到只有使用VBA（API调用，类模块等）才能完成许多事情，专家可以提供关于每种方法对更基本功能的优势的看法（打开表格，搜索等）


Phil

Assuming someone is reasonably proficient at writing both Macros & VBA so that ease of learning is NOT relevant, and also appreciating that a number of things can only be done using VBA (API calls, Class Modules etc.) could the experts offer views on the advantage of each method for the more basic functions (Opening forms, searches etc)

Phil

推荐答案

这是一篇由Bytes主持人几年前撰写的有趣文章，希望它有所帮助。由于发布了较新版本的Access，因此本文的某些内容不再适用。
宏或VBA？

Here is an interesting Article written by a Bytes Moderator some years ago, hope it is helpful. Some of this Article is no longer applicable since the newer Versions of Access were released.
Macros or VBA?

我认为在写这篇文章时，那个人指的是宏，而不是嵌入式宏。


我个人从不使用宏（偶尔会有AutoExec除外），但我试图确定它们是否有任何优势，特别是在使用非Access后端时（SQL Server，MySQL，Silverlight等）

>
Phil

I think that when that article was written, the guy was referring to macros, rather than Embedded Macros.

I personally never use macros (Except AutoExec occasionally), but am trying to establish if they have any advantages, particularly when using non-Access back ends (SQL Server, MySQL, Silverlight etc)

Phil

大家好。


@ADezii。

我很想听到文章中的一些要点不再适用。你有一些例子供我考虑吗？当我再次浏览它时，我看不到任何受新版本影响的东西。


@Phil。

作者是玛丽（麦卡锡）。一个可爱的爱尔兰女士，她不再有太多时间投入Bytes.com，但我不时与之合作。我们都不是ADezii的成员。


我很想知道你所说的嵌入式宏这个词是什么意思/ i>的 ''。我无法遵循这一点，我很害怕。


作为一般规则，即使假设在宏和VBA中都有完整的专业知识，我也会推荐后者，因为除了由于使用宏的性质有限，最简单的项目将需要一些 VBA。那么假设使用VBA，为什么有人会通过兼顾两者来使项目复杂化。我过去继承过那种类型的项目，处理起来并不好玩。一旦所有的宏都被VBA取代，就可以更轻松地工作了。


我希望这是一些帮助。

Hi guys.

@ADezii.
I''m intrigued to hear some of the points in the article are no longer applicable. Do you have some examples for me to consider? I couldn''t see anything affected by new versions when I skimmed through it again.

@Phil.
The author is Mary (McCarthy). A lovely Irish lady who no longer has much time to devote to Bytes.com, but whom I work with from time to time. Neither of us has been a member as long as ADezii here.

I''m curious to understand what you''re referring to with the term ''Embedded Macros''. I couldn''t follow that point I''m afraid.

As a general rule, even assuming full expertise in both macros and VBA, I would recommend the latter, as all but the simplest of projects will require some VBA due to the limited nature of using macros. Assuming then, the use of VBA, why would anyone complicate a project by having some of both. I''ve inherited projects of that type in the past and it was never fun to deal with. Once all the macros had been replaced by VBA it was much easier to work with.

I hope this is some help.

这篇关于嵌入式宏与VBA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！