Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Intro to Visual Studio 2010

Posted on 2014-02-11
5
Medium Priority
?
520 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 2000 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

688 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