Need Code Translated to Basic
I have the following macro in MS Excel, i need it translated into Basic so that i can run the same macro on Open Office.
Can anyone help.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then
Dim Msg, Style, Title, Response
Msg = "Do you want to update YTD?"
Style = vbYesNo + vbQuestion
Title = "Earnings"
Response = MsgBox(Msg, Style, Title)
If Response = vbNo Then
Exit Sub
Else
[d2].Formula = [d2].Value + [c2].Value
End If
End If
End Sub
Re: Need Code Translated to Basic
Re: Need Code Translated to Basic
I dont know what basic, i dont think it is visual basic. When i go into Open Office the editor just says Basic. This is my first time using Open Office yet alone write a macro, and if i put in my excel macro in it, it doesnt work.
Re: Need Code Translated to Basic
I don't think it's a Basic language.... I think it means Basic mode vs. Advanced mode... ???
Tg
Re: Need Code Translated to Basic
What is "Open Office"?
I'll see if I can find something that might point you in the right direction.
Re: Need Code Translated to Basic
Open Office, is like a freeware version of MS Office. Its just like MS Office it opens up all the documents that are generated in MS Office, but it is free. Seems to me its like Linux is an alternative to Windows.
Re: Need Code Translated to Basic
It's cross platform... I use ot at home from time to time. http://openoffice.org -- it's lineage comes from StarOffice from Sun. They took a basline of it, shifted it over to open source, renamed it OO. Now it's run by a group much the same way Mozilla/Fx is run.
Tg