View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Wills Rob Wills is offline
external usenet poster
 
Posts: 18
Default convert constant string to integer

Hi,

Im looking to return the value of an object constant from the string
equivelent.

As an example I am passing "adInteger" as a string, and wish to return the
integer value (from ADO).

I know this can be laid out in a case statement - but I thought there might
be a better way.

I've tried CallByName - but I couldn't get this to work

Any other suggestions?

Many thanks
Rob