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
Hey! I followed exactly what you shared, even with the different method but could not get it to work on the google sheets. My apologies in advance for my lack of knowledge, but do you need to substitute any of the names with my sheet name? I actually only have the VBA coding for the dropdown list to be able to select a few of the items instead of only selecting one item. Sometimes it works when I clicked on "run" and the dialogue box for my sheet appeared but the dropdown list is still not working, and sometimes i failed the "exceeded maximum execution time". Thanks in advance!
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.
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
Here's a video where I explained one way to export or upload data to google sheets: ruclips.net/video/bebQ-Rws0rs/видео.htmlsi=j2NaCuNpndNZdKHe In this other video i show various methods to import data from google sheets: ruclips.net/video/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: ruclips.net/video/VmlSN-C2GGo/видео.htmlsi=P6eRmywf7SHNSs3q
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
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
The last bit about creating independent web applications was very intriguing, I'd like to learn more about it.
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
Hey! I followed exactly what you shared, even with the different method but could not get it to work on the google sheets. My apologies in advance for my lack of knowledge, but do you need to substitute any of the names with my sheet name? I actually only have the VBA coding for the dropdown list to be able to select a few of the items instead of only selecting one item. Sometimes it works when I clicked on "run" and the dialogue box for my sheet appeared but the dropdown list is still not working, and sometimes i failed the "exceeded maximum execution time". Thanks in advance!
Thanks! I really liked this! :)
Glad you liked it!
so to sum up, to write 'macros' in google sheets we need to know javascript ?
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.
omg thank you so much!
Thanks for the feedback!
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.
Will try!
@@ExcelMacroMania Thank you!
Hey, can AI comvert vba code to sheets style??
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
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.
Here's a video where I explained one way to export or upload data to google sheets: ruclips.net/video/bebQ-Rws0rs/видео.htmlsi=j2NaCuNpndNZdKHe
In this other video i show various methods to import data from google sheets: ruclips.net/video/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: ruclips.net/video/VmlSN-C2GGo/видео.htmlsi=P6eRmywf7SHNSs3q
tanks
I watch this video and do all of you say. but when click for turn script, compile error has been show@@ExcelMacroMania
what if my run goes to the title of the whole excel spreadsheet and not the sheet1.?
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
@@ExcelMacroMania ok thank you ill give it a go.
I got an error as getName is not a function in googlesheets
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
p̳r̳o̳m̳o̳s̳m̳ 🙃