Solved

Intro to Visual Studio 2010

Posted on 2014-02-11
5
501 Views
Last Modified: 2014-02-14
Hi, I think this is an easy question. I have .exe I inherited as part of my job. I didn't write it, I don't have any familiarity with coding. It calls an excel spreadsheet that sits on my C. Drive and manipulates data I put in it for analysis.

Recently, our IT department rescinded our admin rights to our computers, which means I can't modify an excel spreadsheet on my C. Drive anymore.

I opened the file and I have the code. I see where it looks to the C. Drive and I was going to change it to "my desktop" instead.

However, I don't know how to use Visual Studio at all. Can someone tell me, once I change the line of code from C Drive to Desktop, how to remake the .exe so I can use it again?

I have Visual Studio 2010.

Thanks!!
0
Comment
Question by:Coaster_brook_trout
[X]
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
  • 3
  • 2
5 Comments
 
LVL 25

Accepted Solution

by:
Luis Pérez earned 500 total points
ID: 39850084
Very easy. If you have changed the "C:\" for your desktop path, the only thing you need is to re-build the EXE. For that:

1. Check your "Solution Explorer". Usually it's located on the right in the Visual Studio window. If you don't see "Solution Explorer", click on the "View" menu and then click in "Solution Explorer" in order to show it.

2. Your solution explorer must show a Solution node (root) and one or more project nodes (children of the root node). If there are more than one project nodes, the one that you need to build is the one in which you've been working (where you changed the "C:\" path).

3. Right-click on the project node that you need to build and then, in the context menu, click on "Build" or "Rebuild".

4. Wait until the project is built. You can see in the Status Bar (at the bottom) a message saying that all was right.

5. Right-click again in your project node and then click on "Open folder in Windows Explorer". Once Windows Explorer appears, you should see a "bin" folder.

6. Open the "bin" folder. Inside it, you should see a "Debug" folder, or a "Release" folder, or both of them. Your new .EXE file is inside one of them, depending on the solution configuration.

7. Check the .exe files inside the "Debug" and "Release" folders (if both exists, if only one of them exists, then go there), the one with the most recent modification date is your new .exe. But ignore the .vshost.exe files, only the .exe files.

Hope that helps.
0
 

Author Comment

by:Coaster_brook_trout
ID: 39850222
Oh I'm sorry, I should have said all I have is the code in a .doc file. So I need to somehow create a new visual studio file. It's confusing because as soon as I open the software it asks me to pick a template and then when I do, I don't know where to copy and paste the code.

I did see the solution explorer menu though!
0
 
LVL 25

Expert Comment

by:Luis Pérez
ID: 39850231
Well, that's a bit more complicated. Depends on the project type and many other things. Can you post the .doc file with the code?
0
 

Author Comment

by:Coaster_brook_trout
ID: 39850277
yep I took out my name and the name of the spreadsheet in the path I modified so my name wasn't all over the internet, but here is the rest posted.
macro.docx
0
 
LVL 25

Expert Comment

by:Luis Pérez
ID: 39850372
Well... here's where I can't help you anymore.

I've been testing your code... you have not the complete code (for example, there are "using" directives missing) and the code is using some references that are missing too... so I'm sorry I can't make your code work.

Maybe another expert can help.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

734 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