473,327 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

vb.net+excel

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.
Nov 21 '05 #1
3 1189
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?

"VladimirHorowitz" wrote:
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.

Nov 21 '05 #2
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)
Nov 21 '05 #3
"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
Nov 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Benjamin | last post by:
I am making a Windows EXE (.NET Visual Basic Windows Application). I would like to make it possible to open Excel Worksheets from my EXE. This should work independent of Excel version on client...
1
by: ʹÃûÑï | last post by:
hi: purpose: clone the firest sheet in Excel.xls into excel2.xls here is my code it well done in winform£º ------------------------------- string SubFile=@"D:\Excel2.xls"; string...
1
by: A B | last post by:
Hello, I have the following two lines in my VB.NET code to cause a datagrid to output in Excel format: Response.ContentType = "application/vnd.ms-excel"...
1
by: George Homorozeanu | last post by:
We create an excel object with Excel/Office Interop Assembly and we want to offer this excel object as download without creating physically the file. The download window appears with "Save As.",...
2
by: Per Ove Steinsland | last post by:
Hi group. I'm using a .NET component from a 3.party supplier that my company uses. I have a problem using msgboxes, they appear NOT in the suppliers app but in my app.-in its own window .. To...
11
by: BrianDH | last post by:
Hi Is there a way, in VB.Net, to write a windows based program that will use more than one version of Office (Excel)? Example: if office 2000 then else if office 2003 then. Is this possible? ...
1
by: Tony Hedge | last post by:
Hello, In my .NET code behind, I open up an excel file, and process all the rows in the worksheet that I'm interested in. Problem is when I'm done and issue the quit method. The EXCEL process...
0
by: sandhya | last post by:
Iam facing a peculiar issue when i try to reference a .net dll within a .net Excel Addin dll created through Extensibility projects. Whenever i try to create the object of the class in the...
0
by: fjlaga | last post by:
I wrote an Excel Add-In in VB.NET using Visual Studio .NET 2003 and the ..NET Framework version 1.1.4322 on my previous machine. This machine had MS Office 10 installed on it. With this...
1
by: No_Spam | last post by:
I'm using Microsoft Excel Object 11.0 (Microsoft.Office.Interop.Excel) to open excel from my web application and set few cells values before displaying it to users. When I deployed the website to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.