如何将VBA转换为Google Apps脚本?

问题描述

我的公司正在从Microsoft Office切换到Google文档，我有这个(几个)代码要在Google Spreadsheets中使用，但是我不知道该怎么做.

My company is switching from Microsoft Office to Google Docs, I have this (several) code I want to use in Google Spreadsheets but I have no idea on how to do that.

请考虑以下代码示例:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("E:J")) Is Nothing Then
        Cells(Target.Row, 1) = MonthName(Month(Date))
        Cells(Target.Row, 2) = Format(Now, "mm/dd/yyyy")
    End If
End Sub

推荐答案

如果要从VBA转换为GAS，那么确实有一个站点必须看起来 http://ramblings.mcpher.com/

If you want to convert from VBA tot GAS there is one site you really must look http://ramblings.mcpher.com/

如果该站点无济于事，我想您是大麻烦了！

If that site doesn't help, I guess you're in big trouble!

这篇关于如何将VBA转换为Google Apps脚本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！