G
Guest
I recently got a new computer with XP Pro on it. I transferred over my files from the old Win 2000 computer and got things running fine for the most part. The problem is I am seeing weirdness with MS Excel 2002 in one regard...the relative path of the file you wish to save to.
The problem manifests itself as an inability to use the Save As command in Notepad when you create a hyperlink pointing to a file that's in a directory other than the one containing the spreadsheet.
Steps to recreate this bug:
1. create a temporary directory on your hard drive (i.e., c:\temp)
2. open c:\temp and create a subdirectory (i.e., c:\temp\test)
3. open c:\temp\test and create a Notepad text file placing any text in it you like and saving it as c:\temp\test\mytext.txt
4. open a new MS Excel spreadsheet and save it to the c:\temp directory (i.e., save as c:\temp\mytest.xls). Be sure to save the file before going to the next steps. If you don't, then the following steps won't replicate the problem.
5. in the first column create a hyperlink (right click on the cell and select Hyperlink from the context menu) to the text file you created (c:\temp\test\mytext.txt)
6. Within the spreadsheet, click on the new hyperlink and the text file will open in Notepad.
7. In Notepad, attempt to save the file as another file name using the Save As command.
At that point, I get this error dialog box popped up:
NOTEPAD
Common Dialog error (0x3002).
The only way around the problem appears to be that you mnust enter the fully qualified path to the file in the Address section at the bottom of the Save As dialog, instead of allowing the default. For example, enter this:
c:\temp\test\mytest.txt.
This Save As command worked fine in Windows 2000, but seems to be specific to XP.
For comparison purposes, try copying the text file into the same directory as the spreadsheet. Then change the hyperlink in the spreadsheet to point to that file. In that case, you CAN use the Save As command as expected. It seems to only occur when pointing to a sub-directory or directory other than the one containing the spreadsheet.
The problem manifests itself as an inability to use the Save As command in Notepad when you create a hyperlink pointing to a file that's in a directory other than the one containing the spreadsheet.
Steps to recreate this bug:
1. create a temporary directory on your hard drive (i.e., c:\temp)
2. open c:\temp and create a subdirectory (i.e., c:\temp\test)
3. open c:\temp\test and create a Notepad text file placing any text in it you like and saving it as c:\temp\test\mytext.txt
4. open a new MS Excel spreadsheet and save it to the c:\temp directory (i.e., save as c:\temp\mytest.xls). Be sure to save the file before going to the next steps. If you don't, then the following steps won't replicate the problem.
5. in the first column create a hyperlink (right click on the cell and select Hyperlink from the context menu) to the text file you created (c:\temp\test\mytext.txt)
6. Within the spreadsheet, click on the new hyperlink and the text file will open in Notepad.
7. In Notepad, attempt to save the file as another file name using the Save As command.
At that point, I get this error dialog box popped up:
NOTEPAD
Common Dialog error (0x3002).
The only way around the problem appears to be that you mnust enter the fully qualified path to the file in the Address section at the bottom of the Save As dialog, instead of allowing the default. For example, enter this:
c:\temp\test\mytest.txt.
This Save As command worked fine in Windows 2000, but seems to be specific to XP.
For comparison purposes, try copying the text file into the same directory as the spreadsheet. Then change the hyperlink in the spreadsheet to point to that file. In that case, you CAN use the Save As command as expected. It seems to only occur when pointing to a sub-directory or directory other than the one containing the spreadsheet.