Execute a string as a VBA statement

[Guest]

Is there a way to execute a string as a VBA statement?

For example something like:
Execute "Msgbox"

I am looking for a means to assemble and execute a VBA statement as a string
similar to the means to execute a SQL statement such as:
CurrentProject.Connection.Execute "DELETE FROM [tblCustomers] WHERE ......"

However this example works only for SQL statements. I am looking for a
similar means to execute a VBA statement.

Jack Cannon

 

[John Nurick]

Hi Jack,

The nearest thing is the Eval() function.

Is there a way to execute a string as a VBA statement?

For example something like:
Execute "Msgbox"

I am looking for a means to assemble and execute a VBA statement as a string
similar to the means to execute a SQL statement such as:
CurrentProject.Connection.Execute "DELETE FROM [tblCustomers] WHERE ......"

However this example works only for SQL statements. I am looking for a
similar means to execute a VBA statement.

Jack Cannon

 

[Guest]

Thanks John,

While that is not exactly what I was looking for, I believe that it will
probably solve my problem.

Jack Cannon

Hi Jack,

The nearest thing is the Eval() function.

Is there a way to execute a string as a VBA statement?

For example something like:
Execute "Msgbox"

I am looking for a means to assemble and execute a VBA statement as a string
similar to the means to execute a SQL statement such as:
CurrentProject.Connection.Execute "DELETE FROM [tblCustomers] WHERE ......"

However this example works only for SQL statements. I am looking for a
similar means to execute a VBA statement.

Jack Cannon

 

[Guest]

Hi Jack,

If you run into the "Error 2482" problem, you may have to ensure that the
string you pass to Eval() is properly "Quoted." For example"

Eval("'" & <My_Custom-Built_Expression> & "'")

Good luck,

Ed

Hi Jack,

The nearest thing is the Eval() function.

Is there a way to execute a string as a VBA statement?

For example something like:
Execute "Msgbox"

I am looking for a means to assemble and execute a VBA statement as a string
similar to the means to execute a SQL statement such as:
CurrentProject.Connection.Execute "DELETE FROM [tblCustomers] WHERE ......"

However this example works only for SQL statements. I am looking for a
similar means to execute a VBA statement.

Jack Cannon

 

[Guest]

Good Point!
Thanks Ed.

Hi Jack,

If you run into the "Error 2482" problem, you may have to ensure that the
string you pass to Eval() is properly "Quoted." For example"

Eval("'" & <My_Custom-Built_Expression> & "'")

Good luck,

Ed

Hi Jack,

The nearest thing is the Eval() function.

Is there a way to execute a string as a VBA statement?

For example something like:
Execute "Msgbox"

I am looking for a means to assemble and execute a VBA statement as a string
similar to the means to execute a SQL statement such as:
CurrentProject.Connection.Execute "DELETE FROM [tblCustomers] WHERE ......"

However this example works only for SQL statements. I am looking for a
similar means to execute a VBA statement.

Jack Cannon

 

[Stuart McCall]

Is there a way to execute a string as a VBA statement?

For example something like:
Execute "Msgbox"

I am looking for a means to assemble and execute a VBA statement as a
string
similar to the means to execute a SQL statement such as:
CurrentProject.Connection.Execute "DELETE FROM [tblCustomers] WHERE
......"

However this example works only for SQL statements. I am looking for a
similar means to execute a VBA statement.

Jack Cannon

In addition to the Eval function, you could also look at the Run method of
the Application object:

Application.Run "MySubProcedureName"

although this doesn't return a value (Eval can), which can be useful
sometimes.