Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Path to Desktop

21 Nov 2010   #1

windows7 home premium 32bit
Path to Desktop

I am using windows 7 and Excel. I have a spreadsheet on the Desktop that I want
to use. I am using VLookup in Excel to access the ss. Here is the path I am trying to
use. =VLookup(A2,'C:\users\max parris\Desktop\[Name.xlsm]Sheet1'!$A$2:$I$700,9,0) When I hit ENTER the following comes up.
C:Liberaries/Documents/. That is all that comes up. The spreadsheet does not open.
How do I set the path from the spreadsheet to the Desktop so that the VLookup can retreive the data. Thanks

My System SpecsSystem Spec
21 Nov 2010   #2
Microsoft MVP


What happens when you click on it?

Rightclick Properties>Open With look for Excel or Change>browse to MS Office>in edition folder (2010, etc) there will be an Excel.exe to add, select "always open this type of file with this program" and Save.
My System SpecsSystem Spec
21 Nov 2010   #3

windows7 home premium 32bit

Thanks for your response. I found the problem. A mistake on my part.
My System SpecsSystem Spec


 Path to Desktop

Thread Tools

Similar help and support threads
Thread Forum
path name
how do I show path in windows 7
General Discussion
Open a new window with "full path" instead of Search Results\"Path"
How can I make it such that in Search Results, when I open a folder in a new window (by right-clicking a file), I will be directed to a window with the "full path" displayed in the address bar, instead of Search Results\"Path" or Search Results>"Path"? Edit: "Right-click -> open file location"...
General Discussion
How to change default desktop shortcut path for new installs
Hi, I recently changed the default install path on Windows 7 from C: to D: using regedit. However now all software and games I install have their desktop shortcut defaulted to the old install path on C:\Program Files\ which of course means they don't work and I have to change the shortcut...
full path to My document and Desktop...
Hi. I want to know the full path to documents and desktop in windows 7, and I want to full path for all users. the problem is when I look in my c:\users\public there is no documents nor is there a desktop folder. I don't want to specify a user's name to a path since my application (.exe) can and...
General Discussion
Which path for me?
Hello SevenForums, I was wondering if you would kindly help me. My name is Darren and I'm from the UK. I've just turned 17 and I am due to start the Zenos IT academy where I will be working towards a diploma to become a Microsoft Certified System Administrator along with an NVQ level 3. I'm...
Chillout Room

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:21.
Twitter Facebook Google+