Microsoft Excel 2016 - Macros not working - This is the REAL solution - Microsoft Community

your microsoft excel/vba keep crashing, think microsoft needs redevelop vba scratch

i have kept quiet while, tonight have decided speak out microsoft excel 2016.

a product in areas, poor in others !,  tired hear, feel , experience microsoft not pulling it's weight.

yes, have @ point had pay microsoft incidents solve technical problems, !  !  

you want pay fix should working  ?

today, frustrated learn has been working years broken affecting client due microsoft's updates,  join queue hear say.  no, it's not fact bugs occur, have been watching slow decline in quality of microsoft applications, , increase in windows updates, application updates , slowness of operating systems windows 10, in particular - wasting time having click, click , click, when before straight forward.

i beginning think microsoft has lost plot.

my company develops in various languages, including using microsoft c++,c#.net , vba macros, java etc name few.

i writing here tonight, because know many of experiencing, excel crashing , maybe losing code, data or both.

in may case, excel could:

1 . vba macro crashes when excel loads up,

2.  when have .xlsm file auto runs vba code on load. may or may not password protected.

excel has become flaky, macros fine, when worthy, it's answer crash, crash , crash error information like:

faulting application name: excel.exe, version: 16.0.8326.2096, time stamp: 0x59a4b55d
faulting module name: ntdll.dll, version: 10.0.14393.1532, time stamp: 0x5965ad6c
exception code: 0xc0000374
fault offset: 0x000d9d71
faulting process id: 0x31d8
faulting application start time: 0x01d32376cc819fd1
faulting application path: c:\program files (x86)\microsoft office\root\office16\excel.exe
faulting module path: c:\windows\system32\ntdll.dll
report id: 9d32b7ca-ef83-40a5-8005-ac1ad9c9b20b
faulting package full name:
faulting package-relative application id:

or

faulting application name: excel.exe, version: 16.0.8326.2096, time stamp: 0x59a4b55d
faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
exception code: 0xc0000005
fault offset: 0x00000000
faulting process id: 0x3d84
faulting application start time: 0x01d32365fb203743
faulting application path: c:\program files (x86)\microsoft office\root\office16\excel.exe
faulting module path: unknown
report id: 5b911b0a-8f59-11e7-8316-f816541d282d
faulting package full name:
faulting package-relative application id

i'm going straight point, solve major bug. seems vbe environment loads quickly, , way slow down use sort of file access. know may sound crazy, in case have vba macro auto loading, after login form, or form lots of controls, there needs delay before calling sub/functions.

example

call strtofile("log.txt", "start log" & vbcrlf)    ' create log file

call strappendtofile("log.txt", "loadassetrefsections complete")   'updates log file

call strappendtofile("log.txt", "end log")   'updates log file

in testing commercial application, found out generating log file, prevented excel crashing. odd ??  !!.

a message microsoft - resources , people power - please fix, totally unacceptable ask pay should working, pay something, when pay microsoft monthly subscription 0365.  oh doesn't cover macros ? ... must.

i'd think microsoft mvp able tell me otherwise.

regards

steve

i have update excel crashing, macros make use of objects offending reason why crashes happen. wonder why vba still has no global exception trapping. performing goto in code basic.

e.g.  cpanel.txtforename  = "some name"

where cpanel is form name , txtforename   textbox control.

whist work, crashes intermittently. i've seen vba crashes whenever object not released set myobject = nothing

correct way:

cpanel.txtforename.value  = "some name"

or

cpanel.txtforename.text  = "some name"

macros don't seem compile when there password on project. i.e. whenever remove password, , run macro, runs fine. 

however, when have password on project seems crash again.

Office / Excel / Microsoft Office Programming / Office 2016