Solved

Intro to Visual Studio 2010

Posted on 2014-02-11
5
477 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
  • 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

708 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

18 Experts available now in Live!

Get 1:1 Help Now