G
Gerry Grimm
Problem manifests itself as an inability to use the Save
As command in Notepad when you create a hyperlink
pointing to a file in a subdirectory of where the
spreadsheet is contained.
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 saving it as
c:\temp\test\mytext.txt
3. open a new MS Excel spreadsheet and save it to the
c:\temp directory (i.e., save as c:\temp\mytest.xls)
4. in the first column create a hyperlink to the text
file you created (c:\temp\test\mytext.txt)
5. now, within the spreadsheet, click on the new
hyperlink and the text file will open in Notepad.
6. attempt to save the file as another file name using
the Save As command.
After the 6th step, you'll get an error:
NOTEPAD
Common Dialog error (0x3002).
I can't find anything to get around this problem. This
worked fine within other versions of Windows, but seems
to be specific to XP (am using XP Pro).
For comparison purposes, try copying the text file into
the same directory as the spreadsheet is one workaround.
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 another directory.
Anyone have a clue as to why this is happening?
As command in Notepad when you create a hyperlink
pointing to a file in a subdirectory of where the
spreadsheet is contained.
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 saving it as
c:\temp\test\mytext.txt
3. open a new MS Excel spreadsheet and save it to the
c:\temp directory (i.e., save as c:\temp\mytest.xls)
4. in the first column create a hyperlink to the text
file you created (c:\temp\test\mytext.txt)
5. now, within the spreadsheet, click on the new
hyperlink and the text file will open in Notepad.
6. attempt to save the file as another file name using
the Save As command.
After the 6th step, you'll get an error:
NOTEPAD
Common Dialog error (0x3002).
I can't find anything to get around this problem. This
worked fine within other versions of Windows, but seems
to be specific to XP (am using XP Pro).
For comparison purposes, try copying the text file into
the same directory as the spreadsheet is one workaround.
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 another directory.
Anyone have a clue as to why this is happening?