Replies

Edited by HansV to re-attach the zipped document, it was lost in the server crash of August 2007

Many people, including myself, use Excel’s statistical functions and the Analysis Toolpak. However, Excel has some flaws that you should know when you are using these tools. I summarized many of these flaws in one document, which I wanted to present to the forum. I would appreciate your comments and suggestions.
It’s a zipped pdf document to reduce it to the acceptable file size for uploading.

Thanks a lot to all of you.
Jan , hartstikke bedankt!!

Thanks a lot to all of you.
Jan , hartstikke bedankt!!

Maybe, I should be a little bit more explicit about the macros attached to the template. The template is designed to generate a protocol document for an experiment within an R&D environment. The macro has some functionality in the Document_New and Document_Open events to fire a dialog window which allows the user to fill in document related information, which is stored in an Excel spreadsheet and in the document properties (both general and custom). In addition, new protocol utilities are added to main commandbar of Word (a popup menu). As I understand from your reply, this new popup menu is causing the problem? Does that mean that to avoid Word from prompting to Save the attached template, I should add code like:

Application.DisplayAlerts = False
ActiveDocument.AttachedTemplate.Saved = False
Application.DisplayAlerts = True

Maybe, I should be a little bit more explicit about the macros attached to the template. The template is designed to generate a protocol document for an experiment within an R&D environment. The macro has some functionality in the Document_New and Document_Open events to fire a dialog window which allows the user to fill in document related information, which is stored in an Excel spreadsheet and in the document properties (both general and custom). In addition, new protocol utilities are added to main commandbar of Word (a popup menu). As I understand from your reply, this new popup menu is causing the problem? Does that mean that to avoid Word from prompting to Save the attached template, I should add code like:

Application.DisplayAlerts = False
ActiveDocument.AttachedTemplate.Saved = False
Application.DisplayAlerts = True

Hi Hans

Actually, to be honest, I work with a workgroup template (in the test phase) on a network drive where I have full read-write access. Because I’ve got prompted to save the template, I added a line in the code to automatically save the attached template.

ActiveDocument.AttachedTemplate.Saved = True

Now that I want other users to work with this template, I don’t want them to have write access, but I am afraid that it will cause trouble (what will happen if they’ve got prompted with that question?). Maybe I should organise myself to test it, but I wondered if somebody from the forum had experience with this.
If I put the template in my User Template (where I have full read-write access), I am prompted too to save the template. No difference.

Hi Hans

Actually, to be honest, I work with a workgroup template (in the test phase) on a network drive where I have full read-write access. Because I’ve got prompted to save the template, I added a line in the code to automatically save the attached template.

ActiveDocument.AttachedTemplate.Saved = True

Now that I want other users to work with this template, I don’t want them to have write access, but I am afraid that it will cause trouble (what will happen if they’ve got prompted with that question?). Maybe I should organise myself to test it, but I wondered if somebody from the forum had experience with this.
If I put the template in my User Template (where I have full read-write access), I am prompted too to save the template. No difference.

Bill,

Visit Stephen Bullen’s Excel page. Select the Excel MVP page and you will find an add-in (XY…exe, I can’t remember the exact name) that does the job. http://linkURL[/url%5D
http://www.bmsltd.ie/Excel/Default.html%5B/url%5D
If needed, I can send you the macro I wrote. Just send me a private message.

Edited Mar 13 04 to update link

Maybe the best way is to use data labels. Add an extra column and put the single character B, S or H next to the data-point you want to label. Then use an data label add-in that you can download free of charge: Have a look at this MVP Page for a free add-in to add labels to data points (XYChartlabeler.exe). This add-in requires your graph to be an XY scatter plot.

Edited Mar 13th 2004 to update link

Have a look at this MVP Page for a free add-in to add labels to data points.

Edited Mar 13th 2004 to update link

Thanks, Jan Karel for your additional information. Yes, you can post this article in the Microsoft Excel MVP newsgroup. No problem!

Depending on what you want to do, but if n/N<0.1 (where n is the sample size and N is the batch size), the binomial distribution is a good approximation to the Hyper Geometrical Distribution, using =BINOMDIST(46;431;160/1350;FALSE). It has the great advantage that it allows you to calculate the cumulative value by just switching FALSE to TRUE.

You could add some code in a general module, like this

Sub RotatePortrait()
    With ActivePresentation.PageSetup
        .SlideOrientation = msoOrientationVertical
    End With
    With SlideShowWindows(1).View
       .Next
    End With
 RefreshSlide
End Sub

Sub RotateLandScape()
    
    With ActivePresentation.PageSetup
        .SlideOrientation = msoOrientationHorizontal
    End With
    With SlideShowWindows(1).View
       .Next
    End With
 RefreshSlide
End Sub

Sub RefreshSlide()
Dim lSlideIndex As Long
lSlideIndex = SlideShowWindows(1).View.CurrentShowPosition
SlideShowWindows(1).View.GotoSlide lSlideIndex
End Sub

Now on the slide preceeding the one thay you want rotated, you add an object (e.g. a textbox) and define “Action Settings”. e.g. in the action settings dialog window, select the ‘run macro’ optionbutton and look for the macro e.g. RotatePortrait. On the slide which is presented in ‘Portrait’ you add another object for which you define as Action Setting to run the macro RotateLandscape to return to the previous version.
It is possible you don’t need the RefreshSlide macro, depending on the version of ppt you use.

Jim and Jan Karel,

I am indeed using the same variable. I really don’t understand that the message boxes don’t show up anymore. The strange thing is that I don’t get error messages if I turn off error trapping. I guess it is a memory problem. If you can’t reproduce the problem, then it’s difficult to solve it. I’ve got it on two computers, but not on others. I’ll do what you suggested: clean up the code and change my variable name.

Thanks

Select the series in the chart. Go with the cursor to the commandbar (e.g. position your cursor after SERIES(….)) and press F9 and enter.