LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bypassing a proxy server Ben Excel Discussion (Misc queries) 0 December 13th 06 03:44 PM
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server Seabee Excel Discussion (Misc queries) 0 November 20th 05 12:03 AM
Proxy Error (Connection refused) Sanjeev-DARC Excel Programming 1 July 21st 05 01:33 AM
Getting a Proxy Class into VBA Paul Hastings[_2_] Excel Programming 0 September 22nd 04 04:32 PM
XMLHTTP proxy settings. Beto[_3_] Excel Programming 0 April 12th 04 08:29 PM


All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"