Problem to use Protocol Builder

[malima]

Please, ITried to use the PB, but is not working in my computer, bellow I put a print screen for the initial screen, in the copy area there are some #NAME?

http://img180.imageshack.us/img180/7263 ... deraz4.jpg

I live in Brazil, but I put in the Windows Regional Settings English (EUA), I set in Excel the macro security low, and trust access to VB projects.

Thanks
Malima

[Mark Pierson]

Do you have the Analysis ToolPak installed and enabled (Tools, Add-Ins)?

Do the errors remain if you click the NEW File button?

[malima]

Mark,

Thanks, was not enable, now is working, great!

I'm looking the manual "Protocol-Builder.doc", and in that talk about some files: codes1.txt, codes2.txt, and codes3.txt; do you know were I can found these?

Marcos Lima

[The Robman]

Let me check my computer at work tomorrow to see if I have them there.

[The Robman]

The codes files have been restored to the zip file.

[engeeaitch]

I have exactly the same problem as the Original Poster - I have downloaded protocol-builder-v400.xls, and I am running Excel 2007. Macros are enabled, and the Analysis Toolpak has been loaded. However, when I open the workbook, I get the following message:
"Some of the functions used by protocol-builder have been renamed to work with the English version of the Microsoft Excel Analysis TookPak."
I am using the English (UK) version of Excel (and I have tried the US version as well). Has anyone got this working with Excel 2007?

[Mark Pierson]

Has anyone got this working with Excel 2007?

Excel 2007 changed the way the ToolPak functions are implemented. In XL07, the required functions are now built-in to the default XL function set and are not part of the ToolPak. PB has not been modified to work with this yet. Hopefully Mike will see this and offer some insight on when he thinks he'll get around to the necessary changes.

[engeeaitch]

Thanks for the info - that explains a lot!

I hope others having the same problem get to read this.

[The Robman]

Excel 2007 changed the way the ToolPak functions are implemented. In XL07, the required functions are now built-in to the default XL function set and are not part of the ToolPak.

What sort of coding changes are needed with Excel 2007? And what about the foreign versions of Excel, do they did use different names for the functions?

[Mark Pierson]

What sort of coding changes are needed with Excel 2007? And what about the foreign versions of Excel, do they did use different names for the functions?

Mike made some wholesale changes to KM to totally eliminate the use of the ToolPak functions. Since they're now internal to KM I believe that those changes work on ANY language version. The changes were done back in v9.08 and we haven't had any reports of them not working from international users so I have to assume everything is ok.

Obviously, something similar needs to be done with PB. Since Mike has done some pretty intense things with PB (much the way things are done in KM), he's the guy to change it. I've looked at his KM changes and go cross-eyed trying to figure them out!

As an FYI for you, Rob, XL07 doesn't allow the "named function" trick we used in KM to access those 6 ToolPak functions (now part of Excel's built-in list) which is why PB no longer works with the latest version.

[mr_d_p_gumby]

What sort of coding changes are needed with Excel 2007? And what about the foreign versions of Excel, do they did use different names for the functions?

Mike made some wholesale changes to KM to totally eliminate the use of the ToolPak functions. Since they're now internal to KM I believe that those changes work on ANY language version. The changes were done back in v9.08 and we haven't had any reports of them not working from international users so I have to assume everything is ok.

I am making the same assumption. They should work with any language version of Excel.

Obviously, something similar needs to be done with PB. Since Mike has done some pretty intense things with PB (much the way things are done in KM), he's the guy to change it. I've looked at his KM changes and go cross-eyed trying to figure them out!

This is definitely on my list of to-dos for PB, as soon as it doesn't make me go cross-eyed too! My initial look at this a few months ago showed that the toolpak functions are not as heavily used in PB as they were in KM, so with any luck the job won't be as difficult, but things do need to be tested. At least KM seems to have proven that the changes will work OK.