Path to Desktop


  1. tenspeed2
    Posts : 2
    windows7 home premium 32bit
       New #1

    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
    Max
      My Computer
    Quote Quote

  3. gregrocker
    Posts : 50,642
       New #2

    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 Computer
    Quote Quote

  4. tenspeed2
    Posts : 2
    windows7 home premium 32bit
    Thread Starter
       New #3

    Thanks for your response. I found the problem. A mistake on my part.
    Max
      My Computer
    Quote Quote

 

  Related Discussions
path name
in General Discussion

how do I show path in windows 7
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"...
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...
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...
Which path for me?
in Chillout Room

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...
Our Sites
Site Links
About 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 16:03.
Find Us