Windows 7 Forums


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

Win7 x 6 PC's
California, Florida, Boston
 
 

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 problems?



Thread Tools



Similar help and support threads for: Path to Desktop
Thread Forum
Open a new window with "full path" instead of Search Results\"Path" General Discussion
Which path for me? Chillout Room
Solved Path problem? General Discussion
PATH's and ENVIRONMENT Installation & Setup


All times are GMT -5. The time now is 03:38 PM.


Seven Forums Android App Seven Forums IOS App Follow us on Facebook

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
  

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