编程Excel

问题描述

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

编程Excel有什么选项？你会推荐哪个人刚刚学习编程，但想要完成任务？有没有为他推荐的书籍/资源（高级Excel用户，初学者程序员）或我（中级Excel用户，高级程序员）？

谢谢。我已经开始来记录我们的发现。

解决方案

作为一个很长的时间（业务）的Excel用户和程序员，我建议从一本很好的VBA书开始，重点介绍Basic语言的主要功能，以及如何与Excel对象（工作簿，工作表等）进行通信。我不用担心用户形式，最初 - 我没有使用这些多年 - 我也不会太担心数据库在最初。

我建议专注于两个方面，从基本语言本身开始，将输出写入Debug.Print的立即窗口，忽略Excel附加的事实。您可以通过解决一些来获得非常好的实践，这些问题有利于纯代码解决方案，无需用户界面

之后，我将学习如何与Excel对象交谈，并阅读尽可能多的Excel论坛和网页来提取提示。例如，一次阅读和写入多个单元格的速度要快一个多一个。

是的，VBA并不像大多数专业但它比大多数语言具有一个关键的优势 - 编写更容易，平均用户可以检查，修改和维护，而且业务世界中的检查和灵活性至关重要。与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.

解决方案

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.

这篇关于编程Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！