Code to run a string as code.

Hi Guys,

below is the code I have created.
The code below should work.. IF there is a way of running a string within VBA as code.
I found the "Sub StringExecute(s As String)" online and had hoped that it would work... it does not.

Does anyone know how I can run my "Str02" variable as a piece of code (Str01 is a variable within the code).
Thanks!

Please Login or Register  to view this content.

Rather than try to understand what you are trying to do with code that does not work for what you want, why not explain in simple English what you wish to happen. Read the yellow banner at the top of this page.

In what way does it not work? You have two End Sub statements together so I’d be surprised if it would compile, let alone work.

Originally Posted by TMS

In what way does it not work? You have two End Sub statements together so I’d be surprised if it would compile, let alone work.

Ok, I fixed that, but that wasnt the problem i was trying to fix.
thanks anyways.

Originally Posted by alansidman

Rather than try to understand what you are trying to do with code that does not work for what you want, why not explain in simple English what you wish to happen. Read the yellow banner at the top of this page.

Hi Alan,


I want to make a button connected to a macro that updates a pivot table with today's (or yesterday's data)
see below code:

Please Login or Register  to view this content.

I need the "20211009" (YYYYMMDD) to change to today's date, (or yesterday's date) which I have coded in.


Aka (tomorrow) I will need the macro to run the following code on the 10th of Oct 2021.

Please Login or Register  to view this content.

"Str02" equals the above code, however it is a string and I need VBA to run this string as a piece of code, not as a string.

Please Login or Register  to view this content.

That might work? I will try tomorrow at work to see if it does. (I'm not connected to the server, so I cannot update the data for testing)

Actually... Now that I think about your code ByteMarks, I have a feeling it might not work because the code you suggested doesn't know which parts are strings and which parts are code.. this is why I need the Chr(34) to separate the strings and the code. (hope that makes sense).
(I could be wrong, but I'm 99% sure what you've suggested won't work. I'll try tomorrow and let you know.)

more or less I need:

Please Login or Register  to view this content.

where "Str02" can be ran as code somehow.

Originally Posted by ByteMarks

Maybe something like this?

Please Login or Register  to view this content.

Hey Bytemarks,

What you suggested does work.
Thanks