Office 365与桌面Excel宏 [英] Office 365 versus desktop Excel macros

问题描述

很抱歉，如果标题非常模糊，我已经尝试了一段时间，但是我不得不说我对Office 365及其相关知识知之甚少.

Sorry if the title is very vague, I've been trying to work my way around this for a little while now, but I have to say that I know very little about Office 365 and its abouts.

我在Excel 2010中开发了一系列宏，其中包括数据输入和子流程自动化，但是最近有人告诉我们，我们正在更加明确地迁移到Office 365的在线平台，正如您已经知道，据我所知，Excel Online不支持宏-或实际上不支持任何VBA.

I've developed a series of macros in Excel 2010 that include input of data and automation of subprocesses, but recently we've been told that we're more definetely moving to the Online platform of Office 365, and as you already know, Excel online does not supports macros -or any VBA really, as far as I know.

所以我想知道是否还有另一种方法可以使它起作用?此时，我愿意接受任何想法！

So I was wondering if there was another way to make it work? I'm open to any ideas at this point!

提前谢谢！

推荐答案

[...]我们被告知，我们正在更加明确地迁移到Office 365的在线平台，并且您已经知道，Excel Online不支持宏-或实际上不是任何VBA

[...] we've been told that we're more definetely moving to the Online platform of Office 365, and as you already know, Excel online does not supports macros -or any VBA really

那是正确的. VBA是一种COM技术，对Windows特定的东西有很多依赖性.微软设法使其能够在Mac上运行已经令人印象深刻，而且我什至没有提到制作可行的Mac-VBA编辑器的艰巨工作.

That is correct. VBA is a COM technology that has a lot of dependencies on Windows-specific things. That Microsoft managed to get it to run on Mac is rather impressive already, and I'm not even mentioning the fiendishly complex work of making a workable Mac-VBA editor.

在可预见的将来，Windows桌面将支持VBA，但是使其在Office 365所运行的所有平台上运行都是不现实的，并且不会发生.

VBA will be supported on Windows desktop for the foreseeable future, but making it work on all the platforms Office 365 runs on is simply unrealistic, and isn't going to happen.

那是VBA的去世吗?当然不是.微软知道有数百万个运行VBA代码的关键业务宏工作表正在运行，据我所知，VBA肯定会在Windows的上得到支持.

Is that the death of VBA? Of course not. Microsoft knows there are millions of business-critical macro-enabled worksheets out there running VBA code, and as far as I know VBA will definitely keep being supported on Windows.

如果您的公司正在迁移到Office 365云，则需要使用 office-js :应该已经成为决定全力以赴的因素，网络.如果您的公司还没有准备好移植所有VBA代码，那么根据对VBA代码的业务要求如何，您需要为需要运行VBA代码的工作站保留桌面安装.

If your company is moving to Office 365 cloud, then your VBA code needs to be ported/rewritten in TypeScript, using office-js, from scratch: that should have been a cost that was factored into the decision to go all-web. If your company isn't prepared to have all VBA code ported, then depending on how business-critical the VBA code is you'll want to keep a desktop install for the workstations that need to run VBA code.

Microsoft Office可扩展性团队正在积极监视 office-js 标签，Michael是该标签中的最高回答者.

The Microsoft Office Extensibility team is actively monitoring the office-js tag on SO, Michael being the top answerer in that tag.

由于Office-JS的开发非常活跃，并且绝对欢迎并考虑到用户反馈，因此您可能希望进入内部程序，以从最新的错误修复和新功能中受益.

You'll probably want to get into the insider program to benefit from the latest bug fixes and new features, as Office-JS is under very active development, and user feedback is absolutely welcome and taken into account.

免责声明:我是Microsoft Excel MVP.

Disclaimer: I'm a Microsoft Excel MVP.

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