Excel Macros in Google Sheets: An Introduction to Google Apps Script

Подписаться 6 тыс.

Просмотров 20 тыс.

50% 1

You can read the post here: excelmacrofun.blogspot.com/20...
In this video wel see how to create Excel macros in Google Sheets, and more specifically, we compare the two leading spreadsheet applications, side by side, in regards to automation and the creation of macros. It is possible to replicate Excel macros in Google Sheets in many cases, yet there are some limits to achieve everything we do in Excel. On the other hand, macros in Google Sheets allow to easily integrate with other Google APIs and web resources, and can even be taken to another level to create entire web applications. However, the programming language we use to code the macros is quite different altogether. Microsoft Excel uses Visual Basic for Applications (VBA), while Google Sheets uses Google Apps Script. This post will help you leverage your Excel VBA knowledge to quickly get up to speed with creating macros in Google Sheets.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)

Опубликовано:

5 авг 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@timurdothamzin Год назад

The last bit about creating independent web applications was very intriguing, I'd like to learn more about it.

@ExcelMacroMania Год назад

Yes, you can create independent web applications with Google Apps Script. I may cover something about that in the future, but is kind of outside the scope of the channel (not Excel VBA/macros anymore). But to give you an example, here's a "web app", i.e. a Sudoku player, that I created with Google Apps Script (obviously contains some HTML/CSS and JavaScript too): script.google.com/macros/s/AKfycbyt8txgq9AweI5-Qy9TfGwRzUorrDW5HqcIy6jqVA6TpwWh2hP-81EVo9Ymjwsq4eIKzw/exec And here's embedded into a Google Sites to make it look a bit nicer: sites.google.com/view/sudokupro

@user-gl4wc2do9p Год назад

Thanks! I really liked this! :)

@ExcelMacroMania Год назад

Glad you liked it!

@victoriachun119 Год назад

omg thank you so much!

@ExcelMacroMania Год назад

Thanks for the feedback!

@grzegorz2852 2 года назад

so to sum up, to write 'macros' in google sheets we need to know javascript ?

@ExcelMacroMania 2 года назад

Yes rather need to know Google Apps Script, which is quite similar to JavaScript, and yet it has some similarities to VBA too in the way of working with the spreadsheet objects as shown in the video.

@roseannarabia6461 4 месяца назад

Can you create a video for making your own word search puzzles in Google sheets like you did for Excel? I would be very grateful if you could.

@ExcelMacroMania 4 месяца назад

Will try!

@roseannarabia6461 4 месяца назад

@@ExcelMacroMania Thank you!

@aliutkutekin3181 2 месяца назад

Hey, can AI comvert vba code to sheets style??

@ExcelMacroMania 2 месяца назад

I wouldn't call it AI, but there are indeed some programs out there that convert Excel macros to sheets. I haven't used it though because I prefer to code it myself. I doubt they are too accurate, is not as easy as a simple "translation", but you may give it a try. See for example here: workspace.google.com/marketplace/app/macro_converter/383201976440

@arislemus1442 Год назад

what if my run goes to the title of the whole excel spreadsheet and not the sheet1.?

@ExcelMacroMania Год назад

ActiveSheet.Name will give you "Sheet1" or whatever is the active sheet. But to get the name of the Excel spreadsheet or file (or workbook), you heed to use ActiveWorkbook.Name. And put that into a variable or display in a message box, otherwise that line of code prompts an error. mySpreadsheetName = ActiveWorkbook.Name MsgBox mySreadsheetName

@arislemus1442 Год назад

@@ExcelMacroMania ok thank you ill give it a go.

@user-gk3gt1xt7e 6 месяцев назад

please help me, I need to sync my excel file to Google sheet. actually I need scripts that update google sheet data, when excel file have change.

@ExcelMacroMania 6 месяцев назад

Here's a video where I explained one way to export or upload data to google sheets: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bebQ-Rws0rs.htmlsi=j2NaCuNpndNZdKHe In this other video i show various methods to import data from google sheets: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lqFoVeNpA-4.htmlsi=lI7_p197n9cT4zhI If you want to update "live" while changing things in Excel, you probably need to implement Google Auth2.0 to use Google Sheets API. Another possibility is creating your own API is a similar way as I was doing it in this other video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VmlSN-C2GGo.htmlsi=P6eRmywf7SHNSs3q

@user-gk3gt1xt7e 6 месяцев назад

tanks I watch this video and do all of you say. but when click for turn script, compile error has been show@@ExcelMacroMania

@sakeenasammi1768 10 дней назад

I got an error as getName is not a function in googlesheets

@ExcelMacroMania 7 дней назад

I can assure you that getName() is a function in googlesheets, more specifically is a method of the class Sheet (and also other classes of course). Check the full list of functions here: developers.google.com/apps-script/reference/spreadsheet/sheet