Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 2147352567 (80020009) Could not proxy for user
Error 2147352567 (80020009) Could not proxy for user
The macro below to output Groupwise calendar items to Excel works fine on my PC but fails with the above error message on others and I haven't the faintest idea why. Can anybody throw any light on it for me, please? Thanks. -------- Dim GWApp As Object ' Application Dim GWAccount As Object ' Root Account Dim GWProxyAcct As Object Dim GWCalendar As Object Dim GWAppts As Object Private Sub cmdGo_Click() ' Clear old data Range("A4").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.ClearContents ' Start GroupWise session Set GWApp = CreateObject("NovellGroupWareSession") Set GWAccount = GWApp.login() For i = 0 To 2 ' three proxy names ' Read Proxy name and get appointment messages collection intRow = 4 strProxyName = ActiveSheet.Cells(3, i * 3 + 1).Value Set GWProxyAcct = GWAccount.Proxy(strProxyName) Set GWCalendar = GWProxyAcct.Calendar Set GWAppts = GWCalendar.Messages ' Read dates dateStart = Worksheets("CalSearch1").Cells(1, 2).Value dateEnd = Worksheets("CalSearch1").Cells(2, 2).Value ' Read dates For Each appt In GWAppts 'Output to Excel if start / end conditions met If DateValue(appt.StartDate) = dateStart And _ DateValue(appt.EndDate) <= dateEnd Then ActiveSheet.Cells(intRow, i * 3 + 1).Value = appt.StartDate ActiveSheet.Cells(intRow, i * 3 + 2).Value = appt.EndDate ActiveSheet.Cells(intRow, i * 3 + 3).Value = appt.Subject & "*" & appt.FromText intRow = intRow + 1 End If Next Next |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 2147352567 (80020009) Could not proxy for user
gb,
You would probably get a better response if you were to point out where the error occurs. Some questions... Do the others have NovellGroupWare installed? Does the ActiveSheet on the others have legitimate entries in Cells A3, D3 and G3? Jim Cone San Francisco, USA "green biro" wrote in message Error 2147352567 (80020009) Could not proxy for user The macro below to output Groupwise calendar items to Excel works fine on my PC but fails with the above error message on others and I haven't the faintest idea why. Can anybody throw any light on it for me, please? Thanks. -------- Dim GWApp As Object ' Application Dim GWAccount As Object ' Root Account Dim GWProxyAcct As Object Dim GWCalendar As Object Dim GWAppts As Object Private Sub cmdGo_Click() ' Clear old data Range("A4").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.ClearContents ' Start GroupWise session Set GWApp = CreateObject("NovellGroupWareSession") Set GWAccount = GWApp.login() For i = 0 To 2 ' three proxy names ' Read Proxy name and get appointment messages collection intRow = 4 strProxyName = ActiveSheet.Cells(3, i * 3 + 1).Value Set GWProxyAcct = GWAccount.Proxy(strProxyName) Set GWCalendar = GWProxyAcct.Calendar Set GWAppts = GWCalendar.Messages ' Read dates dateStart = Worksheets("CalSearch1").Cells(1, 2).Value dateEnd = Worksheets("CalSearch1").Cells(2, 2).Value ' Read dates For Each appt In GWAppts 'Output to Excel if start / end conditions met If DateValue(appt.StartDate) = dateStart And _ DateValue(appt.EndDate) <= dateEnd Then ActiveSheet.Cells(intRow, i * 3 + 1).Value = appt.StartDate ActiveSheet.Cells(intRow, i * 3 + 2).Value = appt.EndDate ActiveSheet.Cells(intRow, i * 3 + 3).Value = appt.Subject & "*" & appt.FromText intRow = intRow + 1 End If Next Next |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 2147352567 (80020009) Could not proxy for user
Error occurs at:
Set GWProxyAcct = GWAccount.Proxy(strProxyName) Thanks for your response but: GroupWise client is installed and all entries are legitimate. Anyone any other ideas? "Jim Cone" wrote in message ... gb, You would probably get a better response if you were to point out where the error occurs. Some questions... Do the others have NovellGroupWare installed? Does the ActiveSheet on the others have legitimate entries in Cells A3, D3 and G3? Jim Cone San Francisco, USA "green biro" wrote in message Error 2147352567 (80020009) Could not proxy for user The macro below to output Groupwise calendar items to Excel works fine on my PC but fails with the above error message on others and I haven't the faintest idea why. Can anybody throw any light on it for me, please? Thanks. -------- Dim GWApp As Object ' Application Dim GWAccount As Object ' Root Account Dim GWProxyAcct As Object Dim GWCalendar As Object Dim GWAppts As Object Private Sub cmdGo_Click() ' Clear old data Range("A4").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.ClearContents ' Start GroupWise session Set GWApp = CreateObject("NovellGroupWareSession") Set GWAccount = GWApp.login() For i = 0 To 2 ' three proxy names ' Read Proxy name and get appointment messages collection intRow = 4 strProxyName = ActiveSheet.Cells(3, i * 3 + 1).Value Set GWProxyAcct = GWAccount.Proxy(strProxyName) Set GWCalendar = GWProxyAcct.Calendar Set GWAppts = GWCalendar.Messages ' Read dates dateStart = Worksheets("CalSearch1").Cells(1, 2).Value dateEnd = Worksheets("CalSearch1").Cells(2, 2).Value ' Read dates For Each appt In GWAppts 'Output to Excel if start / end conditions met If DateValue(appt.StartDate) = dateStart And _ DateValue(appt.EndDate) <= dateEnd Then ActiveSheet.Cells(intRow, i * 3 + 1).Value = appt.StartDate ActiveSheet.Cells(intRow, i * 3 + 2).Value = appt.EndDate ActiveSheet.Cells(intRow, i * 3 + 3).Value = appt.Subject & "*" & appt.FromText intRow = intRow + 1 End If Next Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypassing a proxy server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
Proxy Error (Connection refused) | Excel Programming | |||
Getting a Proxy Class into VBA | Excel Programming | |||
XMLHTTP proxy settings. | Excel Programming |