Outlook VBA How to close a folder after displaying it with code - Microsoft Community
- Get link
 - X
 - Other Apps
 
i have vba test code example below display outlook folder. code in excel workbook should not make difference trying achieve. when finished folder, vba code close folder? (the equivalent of clicking cross top right of displayed folder in interactive mode).
'with code in excel workbook, requires tools -> references -> microsoft outlook 16.0 object library checked
sub opendisplayclosefolders()
      dim olapp outlook.application
      dim olns outlook.namespace
      dim olflder outlook.folder
      
     'have outlook open keep example simple
      on error resume next
      set olapp = getobject(, "outlook.application")
      on error goto 0
      
      if not olapp nothing then
          set olns = olapp.getnamespace("mapi")
          
          'default folder, inbox displayed
          
         'assign folder variable path , name
          set olflder = olns.folders("gmail").folders("macquarie")
          
          olflder.display    'display additional folder
          
         'code here process displayed folder contents    (i have need folder  visible)
          
          '**************************************************************************
          'require vba code example here close folder when finished it
          '**************************************************************************
      end if
   end sub
do not display change current folder.
dim startfolder outlook.folder
        'default folder, inbox displayed
          set startfolder = activeexplorer.currentfolder
           
          'assign folder variable path , name
          set olflder = olns.folders("gmail").folders("macquarie")
           
          'olflder.display    'display additional folder
          set activeexplorer.currentfolder = olflder
           
          'code here process displayed folder contents   (i have need folder  visible)
           
          '**************************************************************************
          'require vba code example here close folder when finished it
          set activeexplorer.currentfolder = startfolder
          '**************************************************************************
                Office                /                        Outlook                    /                        Microsoft Office Programming                    /                        Office 2016                
 
  
- Get link
 - X
 - Other Apps
 
Comments
Post a Comment