MuppetReaper
New Member
- Joined
- Jun 14, 2013
- Messages
- 30
Hi all
I'm trying to specify a certain filepath (happens to be SharePoint) in a FileToOpen command, but it doesn't seem to keep the path when other people use it
the extract of code is below
this always used to work fine, but seems to have stopped recently
We have a mixture of PC's on XP and W7 with Excel 2007 and 2010 - is this part of the problem?
Is there a way to make this go the the folder specified?
thanks
I'm trying to specify a certain filepath (happens to be SharePoint) in a FileToOpen command, but it doesn't seem to keep the path when other people use it
the extract of code is below
Code:
Sub Get_Template()
CurrPath = ActiveWorkbook.Path 'ThisWorkbook.Path
SetCurrentDirectory "\\teamspace.intranet.group\"
FileToOpen = Application.GetOpenFilename _
(Title:="Please choose a file to import", _
FileFilter:="All Excel Files *.xls* (*.xls*),")
this always used to work fine, but seems to have stopped recently
We have a mixture of PC's on XP and W7 with Excel 2007 and 2010 - is this part of the problem?
Is there a way to make this go the the folder specified?
thanks