jana
asked on
Help VBA that opens a folder but and sometimes wont take me to said folder
I been working with a VBA the experts had helped me with where it would open the folder of a PST. The line is
However, the control doesn't take me there all the time to the folder rather opens up the folder - I still have to scroll down to that folder (sometimes it works and takes me there other no-go).
How can modify the above line or what command or function can take me to that folder?
Set oOutlook.ActiveExplorer.currentfolder = oSearchFolder
However, the control doesn't take me there all the time to the folder rather opens up the folder - I still have to scroll down to that folder (sometimes it works and takes me there other no-go).
How can modify the above line or what command or function can take me to that folder?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's about what I had discovered during the prior related question, but was hoping someone might know a way around it...
»bp
»bp
ASKER
So strange... now I log off Outlook and log on, and running the macro, it doesn't go to the folder; like Daniel says "center itself" on the folder name requested. I have tried to recreate when it did run ok, but no way.
Yes, it was somewhat hot or miss when I was testing here too...
»bp
»bp
ASKER
:(
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi!,
Incorprate the script?
That is, replacing the prior in the same line?
Incorprate the script?
Sub Folder_Inbox()
ActiveExplorer.ShowPane olFolderList, True
Set ActiveExplorer.CurrentFolder = Session.GetDefaultFolder(olFolderInbox)
End Sub
That is, replacing the prior in the same line?
ASKER
In my case change olFolderList with FolderName?
ASKER
Nop, didn't work...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
will try
ASKER
Ok, thanx guys! (CTRL-Y does not help; same as going thru the folders as in the left pane- but thank u! The reason is that have a userform that displays the PSTs/folders that when run, opens up the said folder but doesn't take me to the folder - control stays in inbox)
ASKER
Thank u!
Welcome!
»bp
»bp
ASKER