The app can manage excel files, opens them like a database using OLEDB, it also uses an Access Database, then it writes back into the excel file and things like that...
Something like (just in case, an example):
Code: Select all
Imports System.Data.OleDb
Code: Select all
sConnectionString = _
"Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & .FileName & ";" & _
"Mode=Share Deny None;" & _
"Extended Properties=""Excel 12.0;HDR=Yes;IMEX=0;ReadOnly=0;"""
sqlExcel = "UPDATE [Sheet1$] SET COLUMN_A = 'NO' WHERE FIXED IS NULL"
Using oledbConn As New OleDbConnection(sConnectionString)
oledbConn.Open()
Dim oledbComand As New OleDbCommand(sqlExcel)
oledbComand.Connection = oledbConn
oledbComand.ExecuteNonQuery()
End Using
The final user will need to install anything before using my app made with LiveCode in MAC or WIN? I mean something like Net Framework after building something with VS2010... Or I can send them the app and they can use it just like that it doesnt matter if it's MAC or WIN?
That's all for now, thanks
Sorry for my english