Windows 10: Excel VBA massive performance drop likely related to Windows version

Hi, I run into a strange issue with an excel vba macro and could not find any really helpful hint on forums.We deal with a quite complex excel file and a macro which loops through up to 500.000 records, 150 columns accross multiple sheets. The macro usually took around 10 mins to complete on my old laptop Microsoft Surface 8. After migration to a new Microsoft Surface Studio 2, the same macro takes hours to finish.The office versions are exactly the same. Same excel sheet, running at the same time on both devices without any other backend processes and the huge performance difference appears

:)

 

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 on windows phones and tablets

I want to use Powerpoint to prototype an app that I am building. As such I need to customize the PPT file with VBA to do things like have countdown timers, drop down lists, popups etc.

From my research it appears I need a Surface Pro tablet with full office. Anything else like RT won't do the job.

However, I can't determine if a Windows phone will support VBA.

Can anyone confirm if full VBA support is available for Windows phones and tablets? And if so which OS and model.

Thank you,