View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Vision Thing The Vision Thing is offline
external usenet poster
 
Posts: 15
Default VBA Equivalent of ASP 'Execute' Command

Is there a VBA equivalent of ASP's 'Execute' command. I'd like to use such
a command to dynamically declare variables at run-time.

Here's a sample of ASP 'Execute' code.

---------------------------
varID = fp_rs("ID")
varName = fp_rs("Name")
varOccupation = fp_rs("Occupation")

for i = 1 to numFields
Execute("var" & arr_fieldnames(i) & " = fp_rs(""" & arr_fieldnames(i) &
""")"
next

---------------------------

Thanks,
Wayne C.