L
liz
I have some templates whcih use the same information for a user, at
least most of the time. the idea is that the user can select to save
his details for later reuse. This is done using a check box on a
userform associaed with the template. I decided that the best thing to
do woudl be to save the values in the user's Normal template, since
this is their private template. So logically the macro in any template
where this is applicable should do this:
If saveforlater = true
if field(s) don't exist in normal.dot
create them
end if
update field(s) in Normal.dot using entered details (from user
form)
save normal.dot
end if
My questions are this:
1. if I refer to "Normal.dot" will Word find it wherever it is (some
users having it in odd places). I am assuming the answer is yes since
it will be open and therefore Word must know about it. Otherwise do I
need to refer to the full file location and how do I find that out.
2. Since Normal is open, because Word does this on load how do I save
it? I thought the code would be something like this:
"Normal.dot".CustomDocumentProperties.Add _
Name:="test01", _
LinkToContent:=False, _
Value:="<empty>", _
Type:=msoPropertyTypeString
but this causes a complaint because of Normal being open.
thank you.................. liz
least most of the time. the idea is that the user can select to save
his details for later reuse. This is done using a check box on a
userform associaed with the template. I decided that the best thing to
do woudl be to save the values in the user's Normal template, since
this is their private template. So logically the macro in any template
where this is applicable should do this:
If saveforlater = true
if field(s) don't exist in normal.dot
create them
end if
update field(s) in Normal.dot using entered details (from user
form)
save normal.dot
end if
My questions are this:
1. if I refer to "Normal.dot" will Word find it wherever it is (some
users having it in odd places). I am assuming the answer is yes since
it will be open and therefore Word must know about it. Otherwise do I
need to refer to the full file location and how do I find that out.
2. Since Normal is open, because Word does this on load how do I save
it? I thought the code would be something like this:
"Normal.dot".CustomDocumentProperties.Add _
Name:="test01", _
LinkToContent:=False, _
Value:="<empty>", _
Type:=msoPropertyTypeString
but this causes a complaint because of Normal being open.
thank you.................. liz