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
Max

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.
Max
My System SpecsSystem Spec
.


Reply

 Path to Desktop




Thread Tools



Similar help and support threads for2: Path to Desktop
Thread Forum
Open a new window with "full path" instead of Search Results\"Path" General Discussion
Cmd getting gcc out of an unknown path Software
Solved can't seem to find this path General Discussion
Which path for me? Chillout Room
PATH's and ENVIRONMENT Installation & Setup
Best upgrade path from XP Pro? Installation & Setup
DVD Bootmanager Path Installation & Setup

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 02:20 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33