3) If it is an unsaved workbook, we really don't know from the filename what it would be saved with if the .Save command were to be used -- and we don't want to do a normal save prematurely for the user. Dilemma
This is certainly possible. If you are using simple linear regression, then the p-value being so low only means that there is a significant difference between the population correlation and zero. It doesn’t mean that the population value of r is high; it just means that it is not likely...
3) If it is an unsaved workbook, we really don't know from the filename what it would be saved with if the .Save command were to be used -- and we don't want to do a normal save prematurely for the user. Dilemma! So, create a new temporary workbook and save that in the temp...