Windows 10: Having problems with very simple VBA Excel Macros: Command Buttons do not work

Hello !!!Could this be the cause of Command Buttons not working in VBA Excel?The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {C2F03A33-21F5-47FA-B4BB-156362A2F239} and APPID {316CDED5-E4AE-4B15-9113-7055D84DCC97} to the user DESKTOP-UM8ABKR\eaoje SID S-1-5-21-240453450-2420965790-3953455857-1001 from address LocalHost Using LRPC running in the

:)

 

Help with Excel VBA Problem?

Can someone help me code the following VBA problem:

"Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

Thanks!

 

Excel shortcut commands

HI, I am Dave, I will help you with this.

That can be dome with a VBA macro inside the Excel file, but not with a shortcut in Windows, Windows does not have that functionality.

In Excel, you can create a button on the top Toolbar, then add a macro like the one below (replace C:\My Docs\Daily Sales Report) and associate the macro to that button:

Sub SaveAsToday()

ActiveWorkbook.SaveAS ("C:\My Docs\Daily Sales Report" _

& Format(Now(), "DD-MMM-YYYY") & ".xlsx"

End Sub

 

macros in excel?

I'm pretty sure that Macro's are not supported in the phone version as it cannot run VBA.