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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 VBA - CURDIR, not reliable
If you want to know the location of the workbook being opened
p1 = thisworkbook.Path curdir is the current directory for the currently default drive. this isn't necessarily related to the workbook. -- Regards, Tom Ogilvy "Ricke G " wrote in message ... Hi, I'm using Excel 97 and my whish is to use CURDIR as a way of making shure that when having 2 workbooks in a folder somewhere on a drive I will be able to open one from the other. The problem is that I experience different results from this function when having opened a workbook. P1 = CURDIR MSGBOX P1 The short example above gives 2 different results in P1 when being used 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 always 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 Rickard --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 VBA - CURDIR, not reliable
I have a similar situation but with 3 files. i put up
links on the sheet1 of each file for each of the other files. when i wanted to open either of the other files, i just click the link and the other file opened. on the menu barinserthyperlink. click the file button. worked for me. -----Original Message----- Hi, I'm using Excel 97 and my whish is to use CURDIR as a way of making shure that when having 2 workbooks in a folder somewhere on a drive I will be able to open one from the other. The problem is that I experience different results from this function when having opened a workbook. P1 = CURDIR MSGBOX P1 The short example above gives 2 different results in P1 when being used 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 always 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 Rickard --- Message posted from http://www.ExcelForum.com/ . |
Reply |
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 |