View Single Post
 
Old 01-06-2015, 05:12 PM
ptmuldoon ptmuldoon is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Sep 2014
Posts: 93
ptmuldoon is on a distinguished road
Default Referencing FieldCodes in VBA

I'm trying to figure how to either reference or assign a variable to various filed codes like {AUTHOR}. How to do reference the { } brackets? I tried the CHR codes, but it didn't want to work. Any ideas?

Code:
Sub FCTest()
    Dim FC As String
    
    FC = "char(123) AUTHOR chr(125)"
    MsgBox FC
    

End Sub
Reply With Quote