Hello,
First of all, thank you very much for the wondeful forum and help we got from it
I used the excel file in the following thread: excelguru.ca/forums/ showthread.php?776-Copy-Outlook-Calendar-to-Excel
the file works fine on my pc (xp/office 2007) and when we try it on another pc with the same configration, it gives an error messgae:
outlook does not recognize one or more names
80020009
it happens on different pcs with the same configuration
it is really weird, it blocks before having the warning to allow access to outlook for 1/2/5/10 minutes
it blocks on the lines:
Set objRecipient = olNS.CreateRecipient(strSharedMailboxName)
objRecipient.Resolve
Set myCalItems = olNS.GetSharedDefaultFolder(objRecipient, 9).Items '9=olFolderCalendar
can you please help? I tried many things but always same issue
this is quite urgent please, so all help is appreciated as I can't find from where comes the problem
thanks a lot
First of all, thank you very much for the wondeful forum and help we got from it
I used the excel file in the following thread: excelguru.ca/forums/ showthread.php?776-Copy-Outlook-Calendar-to-Excel
the file works fine on my pc (xp/office 2007) and when we try it on another pc with the same configration, it gives an error messgae:
outlook does not recognize one or more names
80020009
it happens on different pcs with the same configuration
it is really weird, it blocks before having the warning to allow access to outlook for 1/2/5/10 minutes
it blocks on the lines:
Set objRecipient = olNS.CreateRecipient(strSharedMailboxName)
objRecipient.Resolve
Set myCalItems = olNS.GetSharedDefaultFolder(objRecipient, 9).Items '9=olFolderCalendar
can you please help? I tried many things but always same issue
this is quite urgent please, so all help is appreciated as I can't find from where comes the problem
thanks a lot