Solved

Intro to Visual Studio 2010

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
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 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 …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

624 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