- #ACTIVATE VBA IN EXCEL 2016 WINDOWS 10#
- #ACTIVATE VBA IN EXCEL 2016 SOFTWARE#
- #ACTIVATE VBA IN EXCEL 2016 CODE#
#ACTIVATE VBA IN EXCEL 2016 WINDOWS 10#
If we're both on the exact same and latest versions of Windows 10 and Office 365 2016, you should produce the same failure. OnĢ016, Task Manager show memory continuously increasing after hang - i.e., Memory Leak. On Office 2010, Task Manager shows a constant 3Mb memory usage throughout the run. On Office 2016, it consistently crashes somewhere between 2500-3000 iterations. This test runs 10,000 iterations just fine on my Office 2010 system in about 5 minutes. I can send you the actual workbook if you provide me your email address. When you run the test, put an iteration count, say 10000, on Sheet 1 cells(6, 3) before clicking the run button. Sheet 1 contains the following code:ĭim todo As Long, done As Long, i As LongĪll you need to do is add a command button on Sheet 1 called cmdRunTest. I have a very simple test workbook to demonstrate this. But some of my VBA apps that run significant loops, consistently hang in Excel 2016.
#ACTIVATE VBA IN EXCEL 2016 SOFTWARE#
In fact, more robust software is generally offset by more powerful hardware as time goes by.ģrd - You missed my main point, which is NOT that it runs slower. The speed of it predecessor, I'd of been terminated. I've developed major software systems for major companies, like IBM and Visa, for 45 years, and if I delivered a new release of a production software system that ran at half YourĮxplanation is Excel itself "consumes" more resources and, therefore, runs slower. I assumed that meant that Office 2016 utilized or made available more resources, like memory, to the user - as in larger and more robust workbooks. It might slowdown a bit until they're complete.Ģnd - I miss-interpreted the statement that "Office 2016 uses more system resources then Office 2010". Sure, during background downloads and installs My Excel VBA runs about the same time first thing in the morning and just before I shutdown at night. If you need further help please upload your file (maybe with anonymous data) on an online file hoster likeĪ macro to anonymize data in selected cells can be downloaded here:ġst - I have a Windows 10 Office 2010 system, and I don't notice any appreciable slowdown throughout the day. The same is true for Excel (and almost any program on your PC), if you compare an old Excel and the newest, you can see a lot of security options, colors, eye catchers.
#ACTIVATE VBA IN EXCEL 2016 CODE#
means your PC has to execute more code to accomplish the same things.
The reason is that your Windows gets updates, new features. If your arguments are right the system has to run at the same speed as in the first time you switched it on. I also created the simple example in Excel 2010 and ran it in Excel 2016 which also worked.And why would the Office community think that its ok for VBA codes to run slower in succeeding versions of Excel? Why would it run slower because Office 2013/2016 uses more system resources then office 2010.ĭid you already noticed that your own PC slow down with the time? So why? I have created a cut down example in VBA 2016 and found that it works as expected. I only see a problem when the Macro is called following a change to the "Introduction" worksheet. Running in Excel 2016, if I access the CreateTimeLine1 macro during normal runtime, it works. The application was written in Excel 2010 and I have just updated to Excel 2016 where the problem is seen. The problem is that in both places shown, I see that the ActiveSheet is the "Introduction" sheet when it should be "TimeInLibraryData" You can see I am outputting the Active Sheet name. Public Sub CreateTimeLine1(PickSingleLib As Long) MsgBox "The name of the active sheet is " & ActiveSheet.Name Sheets("TimeInLibraryData").Visible = True It's pretty simple: Private Sub Worksheet_Change(ByVal Target As Range)
It is triggered by a cell change and then calls a second macro that manipulates another worksheet, "TimeInLibraryData". I have a Macro that is associated with my "Introduction" sheet.
0 kommentar(er)
