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

Thanks! I really liked this! :)

@ExcelMacroMania

11 ай бұрын

Glad you liked it!

omg thank you so much!

@ExcelMacroMania

11 ай бұрын

Thanks for the feedback!

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

@ExcelMacroMania

Жыл бұрын

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.

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

3 ай бұрын

Will try!

@roseannarabia6461

3 ай бұрын

@@ExcelMacroMania Thank you!

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

@ExcelMacroMania

Ай бұрын

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

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.

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

5 ай бұрын

Here's a video where I explained one way to export or upload data to google sheets: kzread.info/dash/bejne/lJmWs4-Lp9aWotY.htmlsi=j2NaCuNpndNZdKHe In this other video i show various methods to import data from google sheets: kzread.info/dash/bejne/nqV60bieftOnXZc.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: kzread.info/dash/bejne/iKGgtbBmc5Wtd9I.htmlsi=P6eRmywf7SHNSs3q

@user-gk3gt1xt7e

5 ай бұрын

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

p̳r̳o̳m̳o̳s̳m̳ 🙃