Using Excel for saves

[greasontim]

So I started playing around with vb.net using Excel for save files.
But I keep having a small issue.
Excel, keeps loading up asking for a password. (Passworded to stop people from screwing with the info)
I don't want it to load up at all, any way to fix this?

[Jackolantern]

If a password has ended up on your Excel file, you can remove it by following the instructions here. If the password has something to do with .NET-to-Excel automation, I am not sure, as I have not done any Office automation since VB6.

[hallsofvallhalla]

i thought there was an excel library you could use to parse the data directly in the file. If you are calling the file then the excel parser is needed.

[theweirdn8]

"Why you no use sql-lite?"

[hallsofvallhalla]

I would agree a DB would be easier but if it is something he is wanting to just easily deploy a text based file solution may be easier.

[Jackolantern]

I do have to agree on SQL-Lite. SQL-Lite basically is a simple, text file-based solution that can easily be deployed with the application if needed. But it is much more advanced than simply using straight flat file or CSV files since it abstracts away much of the parsing and gives you a pretty decent SQL-like experience.

[greasontim]

Already using a .txt file save system, but I'm trying to look into a better save method where they can't edit the character files.
So which would you suggest then?
DB = SQL-lite
or
excel

[Jackolantern]

I am not sure how secure SQL-lite is. You may just want to look into encrypting your IO to a flat file.

[greasontim]

I am not sure how secure SQL-lite is. You may just want to look into encrypting your IO to a flat file.

Any suggestions on to do that?
My encrypting knowledge with vb.net is non-existent

[Jackolantern]

Maybe this could be useful