Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get an object's type if it's declared as Variant
Suppose I have:
Dim objRecordSet as Variant Set objRecordSet = objCommand.Execute How do I get the type of objRecordSet so that I can modify my code and declare objRecordSet specifically instead of as a Variant? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get an object's type if it's declared as Variant
Follow the response to your later post.
Enter "Execute" in the second combo click the search button to its right, with the binoculars. Look at the bottom; you will something like Function Execute([RecordsAffected], [Parameters], [Options As Long = -1]) As Recordset So you can see that this function returns a recordSet object. NickHK wrote in message oups.com... Suppose I have: Dim objRecordSet as Variant Set objRecordSet = objCommand.Execute How do I get the type of objRecordSet so that I can modify my code and declare objRecordSet specifically instead of as a Variant? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky one ( variant type text to be unaffected by a minus) | Excel Programming | |||
how to redim the type of variant element | Excel Programming | |||
Type mismatch accessing variant array too many times | Excel Programming | |||
Variant Array with String Values - Type Mismatch | Excel Programming | |||
How to check a Variant for its data type | Excel Programming |