Windows 10: Recently discovered that Excel will no longer load VBA. I have tried everything - no luck....

Recently discovered that Excel will no longer load VBA. I have tried everything - no luck. Windows 11, MS 365 insider. Tried many combinations of settings. What happened? Version 2407 Build 17816.20000. No error message, no error code.

:)

 

DDE link in Excel crash when I open VBA in Excel wirh Windows10

Good Morning.

I,ve installed windows 10 about 20 days ago.

I've also Microsoft Excel 2007 and I use much VBA Excel and DDE links in my worksheets in Excel.

Before installing Windows 10 I use Windows XP ( with the same Excel 2007 thet I reinstall on Windows 10)

With Windows XP, some times when I need to change istructions in VBA, also if my worksheets was linked with DDE, I opened VBA VisualBasic and I can work in my VBA application.

No problems.

Now, with windows 10, when I open in Excel Visual Basic java links DDE Excel crash.

All works well ( DDE, Excel, and other software ) but whan I open visualbasic in Excel Java Crash.

Any suggest?

Thanks

 

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!

 

VBA Excel Question

I'm going through someone elses code in VBA Excel - how do I know that "FIELD 16" is?

ActiveSheet.Range("$D$2:$R$5000").AutoFilter Field:=16, Criteria1:="="