Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default complication between VB syntax and Object Value with [-] minus character

I'm trying to fetch data from "Active Directory",
the process are :

strQuery = "SELECT AdsPath FROM
'LDAP://ou=xxx,ou=yyy,ou=zzz,dc=ct,dc=abcdefg,dc=net'"
objCommand.CommandText = strQuery
Set objRecordSet = objCommand.Execute
Set objUser = GetObject(objRecordSet.Fields("AdsPath").Value)

Do Until objRecordSet.EOF
formMain.lbstatus.Caption = "Fetching data " & i - 4 & " of " &
objRecordSet.RecordCount
formMain.Repaint
Set objUser = GetObject(objRecordSet.Fields("AdsPath").Value)
ThisWorkbook.ActiveSheet.Cells(i, 3).Value = objUser.cn ' NICK USER NAME
ThisWorkbook.ActiveSheet.Cells(i, 4).Value =
objUser.displayName'LOGIN NAME
ThisWorkbook.ActiveSheet.Cells(i, 5).Value = objUser.sn 'LAST NAME
ThisWorkbook.ActiveSheet.Cells(i, 6).Value = objUser.Title 'TITTLE
ThisWorkbook.ActiveSheet.Cells(i, 7).Value = objUser.mail ' EMAIL Address
ThisWorkbook.ActiveSheet.Cells(i, 8).Value = objUser.msExchIMAddress'
im MAIL Address
ThisWorkbook.ActiveSheet.Cells(i, 9).Value =
objUser.cvx-SourcingCompany 'SourcingCompany

objRecordSet.MoveNext
i = i + 1
Loop



The problem happen when I'm trying to fetch cvx-SourcingCompany, it's
seems like complication between VB syntax and Object Value when using
character "-" that VB think objectUser.cvx [minus] SourcingCompany.

Any Suggestion ?
Reply
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
Plus or minus character ...Its ASCII value Srinivasulu B[_2_] New Users to Excel 6 September 20th 09 06:44 AM
vba syntax for excel object TKoel Excel Discussion (Misc queries) 1 February 10th 09 11:34 PM
Drop Down List complication DoubleZ Excel Discussion (Misc queries) 6 July 14th 08 09:58 PM
Object syntax with a Period ( . ) Neal Zimm Excel Programming 6 March 21st 06 07:28 PM
Drop dow list complication Ryan Excel Discussion (Misc queries) 2 December 16th 04 07:49 PM


All times are GMT +1. The time now is 09:05 AM.

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

About Us

"It's about Microsoft Excel"