Windows7 Default path problem

  • Thread starter Thread starter JohnUK
  • Start date Start date
J

JohnUK

Hi All,
I have just loaded Windows 7 and my workbooks that look for other files in
Documents have now stopped working. I have Documents on a different partition
and have changed the setting in the Windows Documents to look and make the
other Documents the default path, but it still doesn’t work.
This is part of the code that did work:

sPath = Application.DefaultFilePath & "\Folder"
Workbooks.Open FileName:= _
"" & sPath & "\File.xls"

I cant change the code to show the actual path (E:Documents for example) as
other people use the same files on different machines.
Any ideas on how I can get around this so that documents is accessed on any
machine
Regards
John
 
I don't have a solution, but wanted to thank you for the heads-up as I will
be loading Win7 this weekend.
 
Lynda, If you get this message, I found the solution.
Go into Windows explorer, look for the Documents under Libaries on the
C:Drive and change the default path to the Drive you want it to look at
through the Properties tab.
Take care
John
 
Back
Top