
Originally Posted by
snb
I don't see the need to use other folders than the regular ones:
Sub M_snb()
MsgBox Application.DefaultFilePath
End Sub
Thanks, snb
You've lost me! The Folders I was using were normal Vista folders. My Excel worksheet included names of files held in these folders, and I wanted my VBA to run those files.
Since I have lots of new and old working folders I find it useful to mark the key ones so that they stand out visually in file lists, and get sorted to the top of the list. I was doing that by marking them with '##'. I was also using quite complex filenames to a standard format that conveyed a lot of what was in the file. As a result I ended up with paths like this:
C:\Users\Owner\Desktop\##DRAMSOC AREA/##Compiling 1965-1970\##64-5 to 72-3\##Filestore\1964-11-12-St-p1-SavoyOpera+FaragoReview+PicnicOnBattlefield-Raw-070.pdf
But it turned out that though Vista is happy with '##', Excel 2007 VBA is not! So I've replaced '##' with '%%' and all is (I hope!) well!