vb.net: Is there a .NET equivalent to VBA or should I use VBA
Our application allows user to define a "script" on how a telephone call should be taken. There are some built in functions that the user can call from the "script" but I would like to build in the facility to define their own code that can access the .NET classes

Does anyone have any suggestion on the best way to achieve this

Thanks in advance

Hi Cor

I think you got the wrong end of the stick. Or may be I didn’t explain myself very well

My application allows the user to define a "script" which is basically a set of commands (e.g. Enter Post Code, Enter Name, Enter Address etc. this displays text boxes on a form for entry) stored in a table in the back end SQL database. I would like to VBA enable my application (if these are the right words) so that the user could add their own code (dangerous I know but try telling my manager that, or may be it is a good idea I don’t know). Once say the post code has been entered their code would be executed which could perform some validation or whatever they want to do

Cor

Thanks for the pointer. I did a quick search earlier, did come across the link to http://www.eggheadcafe.com/articles/20030908.asp but get an error accessing it, couldn't find anything else hence my post. The link is now working again and I have printed a copy to refer to later, it looks like a good place to start

Hi Chis,

See this the same as converting from VB6.

VBA looks as VB.net, but it is not. However that does not mean, that you can
not paste your VBA code in a "Module" and try it.

I have a maybe strange way to make a module, maybe it helps you also.
Because of that with an empty project not all references are set, I open for
a module a windows form project.

In the code I delete everything.

Than I start making the module with

Public Module my module.
Public sub Main
end sub
end module

And than I set in the projectproperties using the solution explorer the
startup project to sub main.

I hope this helps?

Cor

Hi Chris,

I think that yesterday Vittorio had almost the same question as you and got
a bunch of links.

This is the thread in Google, have a look for it, and it it does not fit
again, message back.

http://groups.google.com/groups?&selm=utu5D7CEEHA.1456%40TK2MSFTNGP09.phx.gbl&rnum=6

If it is not, message back, because it is also for me something I am
investigating.

:-)

Cor

* "=?Utf-8?B?Q2hyaXMgUG9kbW9yZQ==?=" <chrisp@newsgroups.nospam> scripsit:
[quoted text, click to view]

There is no equivalent. You can still use VBA, or you can use .NET for
Office 2003 System.

[quoted text, click to view]

Inside your application?

<URL:http://www.codeproject.com/csharp/livecodedotnet.asp> [C#]
<URL:http://dotnet.mvps.org/dotnet/samples/miscsamples/downloads/DotNetCompiler.zip>

<URL:http://www.codeproject.com/useritems/evaluator.asp>
<URL:http://www.codeproject.com/csharp/livecodedotnet.asp>

If you have a DevX account:

<URL:http://www.devx.com/codemag/Article/10352/0/page/1/>

--
Herfried K. Wagner [MVP]