Hi,
I'm using Excel 97 and my whish is to use CURDIR as a way of makin
shure that when having 2 workbooks in a folder somewhere on a drive
will be able to open one from the other.
The problem is that I experience different results from this functio
when having opened a workbook.
P1 = CURDIR
MSGBOX P1
The short example above gives 2 different results in P1 when being use
in for example the "This Workbook" and "WorkBook_Open Sub".
1. Excel - File - Open - Choose - Open: gives always the right result
2. Excel - File - Open - Choose - Close - File - MRUlist: gives alway
the right result
3. Excel - File - MRUlist: gives different result
4. Filemanager - choose file: gives same as with 3.
Looking for an explanation and a way to make 1 - 4 work safely
Rickar
--
Message posted from
http://www.ExcelForum.com