Saving and opening a named folder using VB

Giganews Newsgroups
Subject: Saving and opening a named folder using VB
Posted by:  rob nobel (robnob…
Date: Mon, 27 Oct 2003

In creating a workbook, I seem to have struck a dificulty in that if the
workbook is transferred to another computer I need to change some of the
code each time (as the other computers run different versions of windows, so
the path to a specific folder is different.)
The code that's affected relates to saving the file and opening the file
using VB code within that file. Is there some way that excel can create a
new named folder and place it in the My Documents folder so that the
procedure would work in allcircumstances?  AND also look for that folder
(wherever it may be found) to open a file.