Form design using Excel VBA

[skulkrinbait]

Hello, I'm a complete novice when it comes to using Excel VBA and am
looking for help and advice please.

I've been given the job of porting some software over from OS2 onto
Windows - this software is used to build code for the companys
systems and it includes a "screen builder" which allows users to
design screens and this also creates the necessary code which generates
the screens when run.

Assuming I can't get the actual screen builder source code to work on
Windows (still looking at this) then I will need a replacement screen
builder and I was wondering if Excel might be able to do it. I've
mocked up a simple screen which looks very similar to the system we use
but obviously it doesn't generate the source code, but the question
is can Excel do this either by using a Macro or Visual Basic?

I'd need some VB which could look at the Excel worksheet/template and
see what has been added and then using that generate some source code
and output it to an IDE, notepad would do but VIM would be better.

I've seen various tutorials for Excel VBA on the net but none of them
are really appropriate for what I want to do - is it possible? The
alternative would be for me to write a screen builder from scratch
which I don't really want to do!

Thanks.

David

 

[skulkrinbait]

I've found this test code on the net:

Sub TextIODemoWrite()
Dim sFile As String
Dim sText As String
Dim iFileNum As Integer

sFile = "C:\test\textio.txt"
sText = "Testing 1 2 3."

iFileNum = FreeFile
Open sFile For Output As iFileNum
Write #iFileNum, sText
Close #iFileNum
End Sub

I can't get it to work, it gives me an error:

"Can't execute code in break mode" and highlights the line: Open
sFile For Output As iFileNum

What did I do wrong?

 

[skulkrinbait]

It's OK, I sussed it out thanks to Google ;-)

I think I should be able to do the rest of it by myself but if anyone
is interested in knowing how I get on then just let me know.