How to convert VBA script to Google Apps Script automatically?

by

There are a few examples of such “conversions” out there – but they are typically re-implementations, not conversions. It’s a subtle difference, but important. While you could feasibly translate from one language to another, the real challenge is in the differences between the underlying object models and available methods in Excel/VBA vs. Google Spreadsheets / Apps Script / javascript.

Your best chance for success is to use the VBA Sub as a kind of specification; if you can clearly explain what functionality is implemented by a VBA Sub, you have the basis for a specification for a new function implemented in your google spreadsheet.

More Related Contents:

  1. Moving google apps script to v8 file upload stopped working from sidebar
  2. How to error handle 1004 Error with WorksheetFunction.VLookup?
  3. Force a screen update in Excel VBA
  4. Find all matches in workbook using Excel VBA
  5. Create a new sheet for each unique agent and move all data to each sheet
  6. Set Auto Filtering multiple wildcards
  7. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  8. How to make Excel VBA variables available to multiple macros?
  9. How to read the correct time/duration values from Google Spreadsheet
  10. How do you do dynamic / dependent drop downs in Google Sheets?
  11. Custom functions intermittently hang with “Error – Loading Data”
  12. When one should use Set [e.g for SpecialCells return value]?
  13. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  14. Determining whether an object is a member of a collection in VBA
  15. VBA ServerXMLHTTP https request with self signed certificate
  16. How to debug Google Apps Script (aka where does Logger.log log to?)
  17. How to add data validation to a cell using VBA
  18. Getting AD Details based on username
  19. Environ Function code samples for VBA
  20. How to copy a chart from Excel to PowerPoint?
  21. How to Transpose / Rotate Multi-dimensional Array?
  22. vba paste not working
  23. mac excel vba loop : from list & then export as pdf
  24. How to add an embedded image to an HTML message in Outlook 2010
  25. Speed up multiple replacement
  26. Excel VBA: auto click and open file from website
  27. How to get the procedure or function name at runtime?
  28. Copy an array reference in VBA
  29. What does the To and Step mean in VBA?
  30. Query my excel worksheet with VBA

Leave a Comment