Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

excel file inside a visual basic project

Posted on 2011-02-14
6
893 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 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