Problems writting special fields from AD to Spreadsheet component

D

Dan Ricker

The first thing I notice (could be just a copy paste error
for the post here).

The line:

objXL.Cells(Row,3).Value = oRS("mobile") 'THIS
LINE FAILS!

Should be: (the ".Value" missing)

objXL.Cells(Row,3).Value = oRS
("mobile").Value 'THIS LINE FAILS!

--------------------------
Other than that, you mention "special field" what
does "special" mean?

Is it possible that the value is null? If so, you can add
a function takes the field as an argument and tests the
value of the field. The function returns a value that the
sheet cell can use.

Note: I'm not sure if a database null can or cannot be
used in a cell...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Special Character at End of Each Table Cell 2
Export Custom Forms in Public Folder to Excel 14
type mismatch error in macro in excel 0
writing a value to a particular cell from function 3
list of fields in gal 0
Extracting Data from Access dB to Excel, using VBA 3
I need to cut characters off of a list of text cells... 2
Macro to copy & paste-special-values data to selected worksheets 1

Top