What is the GetNewValues Parameter of the ConnectData Method For?
In short, set the GetNewValues parameter to True if you always want the initial value of your RTD function to be the return value of the ConnectData method, and leave the GetNewValues parameter alone if you want Excel to use the previous value that it had saved with the Excel spreadsheet. When a workbook with RTD functions is saved as an Excel spreadsheet, then the values of these functions are saved with the workbook. When such a workbook is opened, the ConnectData method is called for each new RTD function. If the GetNewValues parameter is set to True, the saved value is discarded and the return value from the ConnectData method is used. If the GetNewValues parameter is set to False, the saved value is used until that topic has been updated and the return value from the ConnectData method is ignored. By default, the GetNewValues parameter is False if Excel has a saved value, and it is True if Excel doesn’t have a saved value. Note It is not possible to find out the saved value of the
Related Questions
- The GetInfo method can return the full html for the loaded page, using OuterHtml as the parameter I pass in. What if I only want a certain part of the html (for instance, the tag) ?
- What’s the implicit name of the parameter that gets passed into the set method/property of a class?
- Is Cp an empirical Bayes method for smoothing parameter choice?
