From Outlook to Excel Personal Folder
 

Hi all
I want to import both sent and received emails which I have in a personal folder from outlook to excel
I have used this and the inbox folder works:

Set OLF = GetObject("", _
"Outlook.Application").GetNamespace("MAPI").GetDef aultFolder(olFolderInbox)

but I need the public folder roytest instead of the inbox.

Thanks for any help.