Windows 10: Excel 2016 VBA - VBE6EXT.OLB cannot be loaded followed by Out of Memory

I face the error message when opening VBA in my Excel 2016 64bits. I have tried all the methods available in the internet includes:
1. renaming olb

2. copy paste the file into Program Files without x86

3. Run sfc and DIMC
4. adjust ram memory


Please help! 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!

 

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

 

Storing Pictures in Excel Sheet

Hi Now,



I posted the following on the MSDN Excel forum, and the answer was that the suggested method (in particular the VBA) is not available.

But perhaps there is another way to accomplish the task?

I would be ever so thankfull for a good suggestion



Jos



PS: A have experience with VBA, VBScript



---- previously posted:



Hi,

My boss wants me to buy a PDA with Windows Mobile 6. The customer sends a

"normal" Excel-sheet of objects to be inspected. After loading into to PDA

the workers have to take a picture of objects that fail inspection. The

picture then has to be linked to the Mobile-sheet by means of a hyperlink.

I think this is possible used a bit of VBA in Excel, but does Excel Mobile

support VBA?

--

Jos



Answer something like,



I think a no to that.