BookmarkSubscribeRSS Feed
sam1231
Obsidian | Level 7

HI 

 

i AM USING DDE TO INVOKE VBA CODE FROM WORD FOR WATERMARK MY RTF OUTPUT!
But somehow watermarking "Confidential" hide behind table.

 

How to fix this?

3 REPLIES 3
Reeza
Super User

Remove the code that adds it or remove it from the template, if you’re using one. 

If you need help finding the code to delete, please post your code. 

 

PS. All caps is the equivalent of yelling on the internet. 


@sam1231 wrote:

HI 

 

i AM USING DDE TO INVOKE VBA CODE FROM WORD FOR WATERMARK MY RTF OUTPUT!
But somehow watermarking "Confidential" hide behind table.

 

How to fix this?


 

sam1231
Obsidian | Level 7
ODS PATH work.templat(update) sasuser.templat(read)
               sashelp.tmplmst(read);
Proc Template; 
      Define Style Styles.STNDR /*/ Store = SASuser.Templat*/;
             Parent = Styles.printer ;
             replace body from document /
                 leftmargin=1.10in
                 rightmargin=0.6in
                 topmargin=0.75in
                 bottommargin=0.5in
                 ;
              style table from table/
                frame=void
				WATERMARK=ON
      protectspecialchars=off
                rules=groups
                cellpadding=2pt cellspacing=1.25pt borderwidth=0.5pt; 
              Style SystemTitle From TitlesAndFooters /
                 Font = ( "Times New Roman",12Pt,Bold )
                 Just = Center ;

              Style SystemFooter From TitlesAndFooters /
                 Font = ( "Times New Roman",10Pt,Bold )
                 Just = Center ;
    replace HeadersAndFooters from Cell /

                font = fonts('docFont')
                foreground=colors('datafg')
                background=colors('databg')
                protectspecialchars=off;
    
    End ;
run;
Reeza
Super User
WATERMARK = ON seems like where you'd start?

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 743 views
  • 0 likes
  • 2 in conversation