Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Determining the lablel of the pst file just opened
Hi, I have just used the command "myNameSpace.AddStore pstfilename" to open/attach the pst file in Outlook. I know I can change the label property by using the following "myNameSpace.Folders.Item("Outlook Data File").Name = myName" as this is the default label. Q1: Is there any easier way to...- JulesPaul
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to copy mail items to a PST folder file using vba code
Worked Thanks and I guess I will need to handle the sub-directories using a similar method. You are right they don't make it easy.- JulesPaul
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel select a cell in another sheet
Hi, If I understand you correctly you will need the following: Dim wks as worksheet set wks = Worksheets("insert sheet name in these quotes") Sheets(wks.Name).Select ' This changes to the named worksheet Range("A1").Select ' This sets the focus to cell A1. Can have ("A") & row) where...- JulesPaul
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
