Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 VBA - CURDIR, not reliable
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Excel reliable | Excel Discussion (Misc queries) | |||
FAST, RELIABLE, LEGAL MONEY MAKING OPPORTUNITY | Excel Programming | |||
excel 2000 workbook.activate not 100% reliable with alt+tab | Excel Programming |