View Single Post
 
Old 03-09-2021, 11:23 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The first one fails because you can't link to content without telling it which content. Change that to False. It may also fail if the CustomDocumentProperty already exists so you should probably be testing that before adding.

The second one will fail because you told it the value would be a number but you provided a string.

You will also find the date format won't work because you provided a string rather than a valid date. For that one, try Value:=#1/1/2000#
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote