Visual Basic and Dynamic Code.....

Quote:

---

Originally posted by gwdash
i tried adding,

FBExecuteCode("Debug.Print a", False)

and it worked as you wanted
weird

---

That is strange. It does seem to see the var in that case. Doesn't seem to let you modify var contents though.

So close ..... so far

in response to my previous sorry post.

It was not directed at anyone, I had posted a section of code that was odd.

I deleted it before anyone else saw it.

My problem is that the code works fine when I am in the IDE and I hit the run tool bar button.

But the code does not run when I make an executable.
I get an error indicating that it can not find the dll.

Does anyone else have a problem with the code working in the IDE but not in an executable?

Quote:

---

Does anyone else have a problem with the code working in the IDE but not in an executable?

---

This, to me, at this time is the a bit of a 'holy grail' piece of code. I'd very much like to know why the code won't work in an EXE ?

Help P-er-leeze ?

FBP...

attached is the code I am using with VB 6 enterprise.

if you type in:
a=10
msgbox a

you should see a message box with the text 10 in it

now this works from the vb6 ide.

now make an executable and see if it works.
I get an error that the vba6.dll can't be found.


If I change the declare to use vba332.dll I get an error:
cant find the dll
So I change the function declare to point to the dll like this:
Private Declare Function EbExecuteLine Lib "C:\Program Files\Common Files\Microsoft Shared\VBA\vba332.dll" (ByVal pStringToExec As Long, ByVal Foo1 As Long, ByVal Foo2 As Long, ByVal fCheckOnly As Long) As Long

now I get an error as such:
The instruction at "0x65101d27" referenced memory at "0x000000". them memory could not be "read"
click OK to terminate the application
click cancel to debug the application

if I change the declare to find the path of the vba6.dll(it is not in the system32 dir) I get an error like the one above. cant read the memory..........yadda yadda yadda...

see if this works for you(the zip is source code)

Okay, I've got this code in a form:

VB Code:

Option Explicit
Private Declare Function EbExecuteLine Lib "vba6.dll" (ByVal pStringToExec As Long, ByVal Foo1 As Long, ByVal Foo2 As Long, ByVal fCheckOnly As Long) As Long
 
Private Sub cmdRunProcedure_Click()
    FExecuteCode txtProcedure, False
End Sub
 
Function FExecuteCode(stCode As String, Optional fCheckOnly As Boolean) As Boolean
    FExecuteCode = EbExecuteLine(StrPtr(stCode), 0&, 0&, Abs(fCheckOnly)) = 0
End Function
 
Public Sub SubTest()
    MsgBox "This worked"
End Sub

If I type MsgBox "Hello world" into my textbox, it gives me a "Hello world" message box. But, if I type SubTest into my textbox, nothing happens.

Any idea why?

Try preceeding the function call with the object name...

call Form1.mysub

The real questione' is.... does it work in an Exe for U ???

If so why ? cos it don't work for me !

FBP

D'oh :rolleyes:

You're right, though - it still doesn't work in an exe. :(

Ok, I read through all these posts and it looks like you've found the "API" that the debug window uses to run VB code and you're wondering why it doesn't work as an EXE. The answer looks obvious to me.

When you compile your program, it doesn't store things such as comments and variable names. So how can a compiled exe ever run code the user types in as if it's part of the program? The simplest part of the problem is that the variables have no names anymore.

The reason why it works in the IDE is because everything is being compiled with all sorts of debug code so you can step through code and check variables and whatever else you do when you're debugging a program. When you compile the code into an EXE, all the extra debug code is gone. There's nothing for the function to work with. This is just a simple way of putting it. It actually gets a bit more complicated than that.

Also, check out the DLL this is coming from. Chances are, you can't distribute it with your app and it only comes with VB. I could be wrong about that, but I wouldn't be at all surprised if I was right.

Quote:

---

Originally posted by Tygur
Ok, I read through all these posts and it looks like you've found the "API" that the debug window uses to run VB code and you're wondering why it doesn't work as an EXE. The answer looks obvious to me.

When you compile your program, it doesn't store things such as comments and variable names. So how can a compiled exe ever run code the user types in as if it's part of the program? The simplest part of the problem is that the variables have no names anymore.

---

For me it doesn't recognize variables in the IDE. Nothing about it works as an exe.

Ah well, the Holy Grail eludes me again...

One thing, if we can't use this object compiled, whatof' the script control, being a VBScript engine subset, will/can it recognise internal declared functions Anyone know ?

fBp...

Quote:

---

Originally posted by FATBOYPEE
Ah well, the Holy Grail eludes me again...

One thing, if we can't use this object compiled, whatof' the script control, being a VBScript engine subset, will/can it recognise internal declared functions Anyone know ?

fBp...

---

Almost surely not. I will admit I havent tested it though

Quote:

---

Originally posted by FATBOYPEE
Ah well, the Holy Grail eludes me again...

One thing, if we can't use this object compiled, whatof' the script control, being a VBScript engine subset, will/can it recognise internal declared functions Anyone know ?

fBp...

---

you can have many subs in the string to be executed and they can all call each other. You just can't make the leap back into the main prog. You are stuck with passing vars in and out as variants.

Are you thereby saying, if my main Prog has a sub in a module, can I call it using the Script control...

This probably really IS a stupid question.....

fbP..:cool:

Quote:

---

Originally posted by FATBOYPEE
Are you thereby saying, if my main Prog has a sub in a module, can I call it using the Script control...

This probably really IS a stupid question.....

fbP..:cool:

---

no, Im saying you cannot do that (though I havent specifically tested this).

I was just saying the the following type of string sent to the script control will work:

Sub hello()
Call goodbye()
end

Sub goodbye()
msgbox()
end

Guessed as much....

Thanks for that, not quite wot I'm after. I'm after being able to allow a 'framework' kind of listener to call "UserControl"."SubRoutine" without having an object reference. I can use the Callbyname but it needs an object... which the listener won't know.....

humph...:mad:

Thanks again.....:)

Quote:

---

Originally posted by FATBOYPEE
Are you thereby saying, if my main Prog has a sub in a module, can I call it using the Script control...

This probably really IS a stupid question.....

fbP..:cool:

---

check out this prog. should be able to test any "what can the script control do" questions with it.

Enjoy!

Too bad, this ain't JavaScript and HTML, coz there it's real EZ!

I can't wait to try it all out... Does anybody know which DLL is responsible for this API in VBA (Word2000)? :confused:


Thanks All!
Remko