Solved

excel file inside a visual basic project

Posted on 2011-02-14
6
877 Views
Last Modified: 2012-05-11
Let me try to explain my problem, be patient I dont speak english very well
hehehehe

Im doing a Visual Basic project where I use two excel files.

The user can send information to this files and save the files as a new file with his information with format, etc...

Right now this two excel files are in "c:\temp\"

I dont need to create a new excel file everytime that my user wants his information saved in a file

I would like to know how to add this file inside my project, to allow that when the system is installed this two files goes with the installatio too

Best Regards
0
Comment
Question by:altariamx2003
6 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 34891591
in visual studio right click your application...
Choose option Add existing item for each one (excel file)
0
 

Author Comment

by:altariamx2003
ID: 34893421
example.jpg

I tried that, but when I publish the project and after I install the system I cannot find the excel file
0
 
LVL 12

Expert Comment

by:Hairbrush
ID: 34895183
There is one more thing you need to do.  Right click on the Excel file within Explorador de soluciones and then select Properties.  You should see a setting that in English says "Copy to Output directory".  By default it will be set to "Do not copy".  Change this to "Copy if newer".
Copy-file-into-bin.PNG
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34895981
>to allow that when the system is installed this two files goes with the installatio too

Do you have a deployment project as well?
0
 
LVL 12

Accepted Solution

by:
Hairbrush earned 500 total points
ID: 34896086
If you have a deployment project, the .xls files will be automatically deployed to the project's output directory (same directory as the .exe / .dll)

Can you now see the .xls files?
0
 

Author Closing Comment

by:altariamx2003
ID: 34904098
thanks Hairbrush, your are a master!!!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Events in static methods 3 50
Definitions and default visual studio colors 5 58
fso.FolderExists("\\server\HiddenFolder$") 4 46
Help with Syntax 9 24
Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now