If you're going to work with another application, such as Word, declare your OLE object directly, rather than as an Object type variable.
For example, use , VBA can access the object directly, rather than resolving the complete path to the object each time.
This method is useful only when you are accessing an object several times during code execution.
This works in Excel 20 (just verified); I don't have 2016, can't check. The "Now()" function returns the current date and time.
My problem is that even in Automatic calculation mode the cell does not automatically update which it should.
I have so far opened the file and set the active worksheet.
any furher assistance would be greatly appreciated.
When a value is changed, the display of a cell with NOW() does change (assuming the seconds or whatever changes is visible).
If that is what you refer to, it was not clear at all.
The problem is that when I return to the worksheet to check the progress the status bar and worksheet do not refresh/redraw on focus.
Can I force a worksheet (status bar) refresh each iteration? The issue is not returning the status bar back to Excel at the end. If I minimize the worksheet/app and return I can not see the progress unless I Ctrl-Break the running macro. This macro will run for a while as it iterates the source rows and does comparisons.
Open(@Local File Names[i], null, false, null, null, null, null, null, null, true); //ensure the current sheet is active and give worksheet to use.