"VladimirHorowitz" <Vl**************@discussions.microsoft.com> wrote in
message news:D0**********************************@microsof t.com...
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.
--
Regards,
Andy O'Neill