Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows7 Default path problem
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 doesnt 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows7 Default path problem
I don't have a solution, but wanted to thank you for the heads-up as I will
be loading Win7 this weekend. "JohnUK" wrote: Hi All, I have just loaded Windows 7 and my workbooks that look for other files in Documents have now stopped working. <snip |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Windows7 Default path problem
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 "Lynda" wrote: I don't have a solution, but wanted to thank you for the heads-up as I will be loading Win7 this weekend. "JohnUK" wrote: Hi All, I have just loaded Windows 7 and my workbooks that look for other files in Documents have now stopped working. <snip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get default add-in path | Excel Programming | |||
how set default path? | Excel Programming | |||
Problem with default file path | Excel Programming | |||
Default path | Excel Programming | |||
Default Path for Add-Ins | Excel Programming |