vb.net+excel

[Guest]

Hello , all i want to do is the following:

Add an excel sheet in the vb application and finally to be compiled somehow
with the app. I mean, I'd like the excel sheet not to be available to users.
Somehow to "encrypt" the xls file in the exe file of my app.

The alternative solution BUT NOT THAT I WANT is to have 2 files; the .exe
and the .xls (add reference to the app, createobject... the usual)

Hope made myself clear
Any help will be accepted.

 

[Guest]

You can always embed the document in your exe, but do you wish for any Excel
document at any time be created as an external object?

 

[Guest]

I use excel so as to easily create a nice graphical output "form" (cell
colors,font properties, borderstyles etc). When i fill in the textboxes in
the vb.net application the data will be written to some cells of the excel
sheet, then print it and last exit without saving the changes. Noway a user
can copy the excel sheet because it will be contained in the exe file.
Can you help me (steps) on how to add the xls file to the project so i can
access it and do the above?

Thanks.
(my english is not quite good)

 

[Andy O'Neill]

I use excel so as to easily create a nice graphical output "form" (cell
colors,font properties, borderstyles etc). When i fill in the textboxes in
the vb.net application the data will be written to some cells of the excel
sheet, then print it and last exit without saving the changes. Noway a
user
can copy the excel sheet because it will be contained in the exe file.
Can you help me (steps) on how to add the xls file to the project so i can
access it and do the above?

Thanks.
(my english is not quite good)

There's an alternative.
To code the formatting and apply this to a blank sheet programmatically.
You can work out the code does the reformat bit by recording a macro whilst
you do it manually.

If you're concerned the user might break the xls file by messing with it.
You could maybe copy it off a server every time.
Make the users rights to the copy on the server read only and they can't
break it.
Bear in mind it'll likely inherit those rights when you copy.