Calendar Wizard Error - Office Word 2004

[Jerome]

I am trying to install the Calendar Wizard in Word on my Mac. It is a
standard wizard on the PC version but not a default for Mac.

I followed the instructions provided by Word:mac at
http://word.mvps.org/Mac/Using-Windows-Templates.html . The
explanations were awesome (great job). It all looked good until right
at the end. I uncompressed the cab file, renamed the .wiz file, opened
it in word, "save as" in my templates and re-opened it in the project
gallery. The Wizard opens fine, lets me pick all the options but when
I click Finish, I get the following error message:
" Method 'PrivateProfileString' of object 'System' failed", with an
"OK" button. I click "OK" and I only get a blank document.

Details:
Template: 06206263 (aka Calendar Wizard)
Office 2004 for Mac version 11.5.0
Intel Mac 24" 2.4GHz
OS X 10.6.1

Can anyone help me?
Thanks

 

[John McGhie]

Hi Jerome:

Well.....

You have struck one of the templates that "WON'T" work on the Mac.

Method "PrivateProfileString" is an attempt to write to the Windows registry


You will need to edit that code to nominate a text file to use as a
substitute for the Windows Registry. The text file must exist, or you will
get the error.

See the example in the Word 2004 VBA help topic "PrivateProfileString
Property Example".

Cheers

I am trying to install the Calendar Wizard in Word on my Mac. It is a
standard wizard on the PC version but not a default for Mac.

I followed the instructions provided by Word:mac at
http://word.mvps.org/Mac/Using-Windows-Templates.html . The
explanations were awesome (great job). It all looked good until right
at the end. I uncompressed the cab file, renamed the .wiz file, opened
it in word, "save as" in my templates and re-opened it in the project
gallery. The Wizard opens fine, lets me pick all the options but when
I click Finish, I get the following error message:
" Method 'PrivateProfileString' of object 'System' failed", with an
"OK" button. I click "OK" and I only get a blank document.

Details:
Template: 06206263 (aka Calendar Wizard)
Office 2004 for Mac version 11.5.0
Intel Mac 24" 2.4GHz
OS X 10.6.1

Can anyone help me?
Thanks

--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[Jerome]

Hi John,

Well, that's my luck...

Thank you so much for the quick response. I have tried to do what you
suggested, but I am a little lost, this is definitely beyond my skill
level in Word... I found the help section in VBA, below is what it
says.

PrivateProfileString Property Example
This example sets the current document name as the LastFile setting
under the MacroSettings heading in Settings.txt.
System.PrivateProfileString("Macintosh HD:Users:Shared:Settings.txt",
"MacroSettings", _
"LastFile") = ActiveDocument.FullName
This example returns the LastFile setting from Settings.txt and then
opens the document stored in LastFile.
LastFile = System.PrivateProfileString("Macintosh
HD:Users:Shared:Settings.Txt", _
"MacroSettings", "LastFile")
If LastFile <> "" Then Documents.Open FileName:=LastFile

So, which section should I type, the first one, or the second one, and
mostly, where should I type that. When I run the Wizard by doing File-
Project, at the end of the Wizard, it actually closes everything down
(except for Word itself), therefore I can't even get to the VBA
portion. So, I opened the .dot file by double clicking on it. It opens
a blank new file, and I am able to go to Tools - Macro - VBA Editor.
But once in there, I don't know what to do. I try to double click on
the project name in the Projects window, but it says it is locked and
unviewable... What to do?

Also, I believe you say I will have to create a text file to "fake"
the Windows registry. From the example, I guess I can create a
settings.txt file in the Shared folder, but what should it contain, or
should it be just an empty file.

Any additional help would be greatly appreciated.

Thanks
Jerome

 

[John McGhie]

Hi Jerome:

Use File>Open on the template file.

Then go into the VBA editor and look at the Wizard project.

If you can't get that far, they have password-protected the code in the
Wizard and there is no point in thinking about the rest.

When you get into the Wizard, look for the PrivateProfileString statement
(there may be more than one of them).

When you find it, add the complete pathname and file name to it, as shown in
the examples. Don't change the rest of the statement.

Cheers

Hi John,

Well, that's my luck...

Thank you so much for the quick response. I have tried to do what you
suggested, but I am a little lost, this is definitely beyond my skill
level in Word... I found the help section in VBA, below is what it
says.

PrivateProfileString Property Example
This example sets the current document name as the LastFile setting
under the MacroSettings heading in Settings.txt.
System.PrivateProfileString("Macintosh HD:Users:Shared:Settings.txt",
"MacroSettings", _
"LastFile") = ActiveDocument.FullName
This example returns the LastFile setting from Settings.txt and then
opens the document stored in LastFile.
LastFile = System.PrivateProfileString("Macintosh
HD:Users:Shared:Settings.Txt", _
"MacroSettings", "LastFile")
If LastFile <> "" Then Documents.Open FileName:=LastFile

So, which section should I type, the first one, or the second one, and
mostly, where should I type that. When I run the Wizard by doing File-
Project, at the end of the Wizard, it actually closes everything down
(except for Word itself), therefore I can't even get to the VBA
portion. So, I opened the .dot file by double clicking on it. It opens
a blank new file, and I am able to go to Tools - Macro - VBA Editor.
But once in there, I don't know what to do. I try to double click on
the project name in the Projects window, but it says it is locked and
unviewable... What to do?

Also, I believe you say I will have to create a text file to "fake"
the Windows registry. From the example, I guess I can create a
settings.txt file in the Shared folder, but what should it contain, or
should it be just an empty file.

Any additional help would be greatly appreciated.

Thanks
Jerome

--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[Jerome]

Hi Jerome:

Use File>Open on the template file.

Then go into the VBA editor and look at the Wizard project.

If you can't get that far, they have password-protected the code in the
Wizard and there is no point in thinking about the rest.

When you get into the Wizard, look for the PrivateProfileString statement
(there may be more than one of them).

When you find it, add the complete pathname and file name to it, as shownin
the examples.  Don't change the rest of the statement.

Cheers









 --

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

Hi John,

Thank you so much for the help, but as feared, they password protected
the file :-(

I'll create the files using a PC and transfer the files on the Mac.
That's it...

Thanks again
Jerome