Google Answers Logo
View Question
 
Q: Need to execute dynamic code in Excel VBA (Office XP/VBA 6.3) ( No Answer,   0 Comments )
Question  
Subject: Need to execute dynamic code in Excel VBA (Office XP/VBA 6.3)
Category: Computers > Programming
Asked by: davidparks21-ga
List Price: $8.00
Posted: 03 Nov 2003 16:23 PST
Expires: 03 Dec 2003 16:23 PST
Question ID: 272321
I need to execute code dynamically in Excel VBA. I am using Office XP
(VBA 6.3).

This is what I need to do exactly:
I have a VB command stored in a cell in Excel. When I run a script I
need it to execute the code in that cell.

I see that in VB version 5 there was an Execute funciton call which
could do this in VBA. I don't see the same in version 6.3, odd.

Does anyone know of a method of doing this?

Thanks,
David

Clarification of Question by davidparks21-ga on 28 Nov 2003 13:09 PST
Here is an example (psudo code) of what I'd like to do:

------------------------------------------
dim strVariable = "msgbox('Hello')"
execute(strVariable)
------------------------------------------

Where the line "execute(strVariable)" would generate a message box
with the text "Hello" in it.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy