I have the following code that has been working okay in excel 2007, but seems that when we upgraded to excel 2010 (two weeks ago) it has not been working.
Workbooks.Open Filename:="Market Sheet"
ActiveWorkbook.RefreshAll
I can "Step into" the macro, and it works fine, but when I "run" the macro it does not. Do you know if something in excel 2010 changed that may cause this problem?
Bookmarks