编程Excel(Programming Excel)

编程Excel(Programming Excel)

我想给我的男朋友一个编程的味道。 如果这取决于我，我会教Scheme，Haskell或F＃，但是由于他宁愿学习一些可以用作财务顾问的工作，例如编程Excel。

Excel编程有什么选择？ 对于刚刚学习编程而又想完成任务的人，你会推荐哪一种？ 你有推荐给他的任何书籍/资源（高级Excel用户，初学者程序员）还是我（中级Excel用户，高级程序员）？

谢谢。 我开始了一个关于编程Excel的博客来记录我们的发现。

I'd like to give my boyfriend a taste of programming. If it was up to me, I'd teach Scheme, Haskell or F# but since he'd rather learn something that can be useful in his job as a fiscal consultant, i.e. programming Excel.

What are the options for programming Excel? Which one would you recommend for someone who's just learning to program and yet wants to get things done? Are there any books / resources you recommend for him (advanced Excel user, beginner programmer) or me (intermediate Excel user, advanced programmer)?

Thanks. I've started a blog about programming Excel to document our findings.

最满意答案

作为一名长期（商业）的Excel用户和程序员，我建议从一本关于基本语言的关键功能以及如何与Excel对象（工作簿，工作表等）进行通信的优秀VBA书开始。 我不担心用户表单，最初 - 我已经用了很多年 - 我一开始也不会太担心数据库。

我建议重点关注两个方面，首先是Basic语言本身，用Debug.Print将输出写入Immediate窗口，并忽略附加Excel的事实。 通过解决一些欧拉问题 ，您可以获得非常好的实践，这些问题有利于纯粹的代码解决方案，而无需用户界面。

之后，我会学习如何与Excel对象交谈，并阅读尽可能多的Excel论坛和网页以获取提示。 例如，一次读取和写入多个单元比一次写入多得多。

是的，VBA并不像大多数“专业”语言那样功能全面，但它与其中大多数语言相比具有一个关键优势 - 编写起来更容易，而且普通用户也可以更轻松地进行检查，修改和维护 - 而且可检查性和灵活性是在商业世界中至关重要。 与Excel一起，这是一个了不起的商业工具。

As a long time (business) Excel user and programmer, I recommend starting with a good VBA book that focuses on the key features of the Basic language, and how to communicate with the Excel objects (workbooks, sheets, etc). I wouldn't worry about userforms, initially - I haven't used those for years - and I wouldn't worry too much about databases at first either.

I suggest focusing on two areas in particular, starting with the Basic language itself, writing output to the Immediate window with Debug.Print and ignoring the fact that Excel is attached. You can get very good practice in this by solving some of the Euler problems, which favour pure code solutions with no user interface.

After that, I would learn how to talk to the Excel objects, and read as many Excel forums and web pages as possible to pick up tips. For example, it is much faster to read and write many cells at once, than one at a time.

And yes, VBA is not as full featured as most 'professional' languages, but it has one crucial advantage over most of them - it is much easier to write and for the average user to check, modify and maintain - and checkability and flexibility are crucial in the business world. Together with Excel, it is an amazing business tool.