Intro to Visual Studio 2010

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!!
Coaster_brook_troutAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Luis PérezConnect With a Mentor Software Architect in .NetCommented:
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
 
Coaster_brook_troutAuthor Commented:
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
 
Luis PérezSoftware Architect in .NetCommented:
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
 
Coaster_brook_troutAuthor Commented:
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
 
Luis PérezSoftware Architect in .NetCommented:
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
All Courses

From novice to tech pro — start learning today.