Re: Saving and opening a named folder using VB

Giganews Newsgroups
Subject: Re: Saving and opening a named folder using VB
Posted by:  John Wilson (jwils…@optonline.net)
Date: Sun, 26 Oct 2003

Rob,

Just guessing, but are you trying to modify one Excel file via another??
If so, why not use:
ThisWorkbook.Path

If both files are in the same directory (regardless of the what it's named)
it should work.

John

"rob nobel" <robnob…@dodo.com.au> wrote in message
news:O3IJFJDnDHA.32…@tk2msftngp13.phx.gbl...
> Hi,
> 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.
> Rob

Replies

In response to

Saving and opening a named folder using VB posted by rob nobel on Mon, 27 Oct 2003