Ctrl-Shift-P is only to be used for event tabs. It refreshes data from US FIRST website and calculate OPR and CCWM. It is not a update anything you want macro. If you use it on the "OPR results" tab, some data in column B will be erased because that is what I need to do at the beginning of the macro.
If you find that the data in "OPR results" does not have week 4 data, you must be using version 3.0 which only includes data up to week 3. I publish a new file every week. The spreadsheet does not update itself by running a macro.
It is a great idea to put buttons on each page so only those macros will run. However I don't like to do that because when I copy the whole page of data, those buttons keep pasting over and over on top of the buttons that is already there.
As for not showing the screen update while it is running, I didn't know you can do that. Thanks for pointing it out. I learn something new today. However it is a personal preference. I like to see it updating while it is running. That way I know it is doing something and not just got hung up in an infinite loop. You can modify my spreadsheet to suit your preference. It is open source.
Quote:
Originally Posted by BigBen
First, AWESOME spreadsheet!
I am using Windows 7 Home Premium and Excel 2013.
I think the tabs people are having problems with are the combined data pages, all of the competition tabs are updated (minus the alliance pick/tournament results "Column O" of course). The "WM data", "WM results", "OPR data", "OPR results", "Adjusted OPR results", and "Worldrank" tabs do not seem to have been updated with the week 4 results. Using CTRL+SHIFT+P on these pages results in "Microsoft Visual Basic Run-time error '1004': Application-defined or object-defined error". Going to debug, the following line in Module 2 (Code) is highlighted: Selection.QueryTable.Refresh BackgroundQuery:=False
Also, column B, the "Location" data is blank for all but Team 1 in each of those tabs.
Truthfully I don't know if you wanted us to use CTRL+SHIFT+P to update those tabs, but it looks like the last time they were updated was week 3.
I think the easiest thing to do on each tab would be to put a small "radio button" or two at the top of the page that would run the expected macro or macros for each tab. Also, if you want the macro to not show the screen updating while it is running, which should make it faster as well, set "Application.ScreenUpdating = False" at the beginning and "= True" just before the end.
|