Excel saves to wrong folder

In Excel XP, I open two files from a local folder. Then I save (using 'Save
As') the first file to a folder on a network share, when I try and save the
second file to a different folder on the same network share, Excel saves the
second file to the folder the frst file was saved to. I can diplicate this on
multiple machines on multiple domains. I have applied all updates. Is there a
way to stop this from happening? The only work around I have come up with is
to close Excel between each 'Save As' attempt.

when I try and save the second file to a different folder

When you do the second Save As are you saying that Excel will not allow you
to select another folder? Or are you saying that, even though you can
select another folder, Excel will not use it? I've have never run into
either problem (and I just tried it now with Excel 2002).

--
Jim
"T Dragos" T wrote in message
...
| In Excel XP, I open two files from a local folder. Then I save (using
'Save
| As') the first file to a folder on a network share, when I try and save
the
| second file to a different folder on the same network share, Excel saves
the
| second file to the folder the frst file was saved to. I can diplicate this
on
| multiple machines on multiple domains. I have applied all updates. Is
there a
| way to stop this from happening? The only work around I have come up with
is
| to close Excel between each 'Save As' attempt.

I can select the folder, and it appears to save the file, but when I go
looking, the file is in the first folder. Again, the key seems to be the
first "save as" location is sticking when I try the second "save as". I am
using Excel 2002 (10.6816.6817) SP3

"Jim Rech" wrote:

when I try and save the second file to a different folder

When you do the second Save As are you saying that Excel will not allow you
to select another folder? Or are you saying that, even though you can
select another folder, Excel will not use it? I've have never run into
either problem (and I just tried it now with Excel 2002).

--
Jim
"T Dragos" T wrote in message
...
| In Excel XP, I open two files from a local folder. Then I save (using
'Save
| As') the first file to a folder on a network share, when I try and save
the
| second file to a different folder on the same network share, Excel saves
the
| second file to the folder the frst file was saved to. I can diplicate this
on
| multiple machines on multiple domains. I have applied all updates. Is
there a
| way to stop this from happening? The only work around I have come up with
is
| to close Excel between each 'Save As' attempt.

Does this help?

Sub savefileasandcomeback()
originalpath = ActiveWorkbook.Path
MsgBox op
ActiveWorkbook.SaveAs Filename:= _
"YourPath\YourName.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ChDir originalpath
End Sub

--
Don Guillett
SalesAid Software

"T Dragos" wrote in message
...
I can select the folder, and it appears to save the file, but when I go
looking, the file is in the first folder. Again, the key seems to be the
first "save as" location is sticking when I try the second "save as". I am
using Excel 2002 (10.6816.6817) SP3

"Jim Rech" wrote:

when I try and save the second file to a different folder

When you do the second Save As are you saying that Excel will not allow
you
to select another folder? Or are you saying that, even though you can
select another folder, Excel will not use it? I've have never run into
either problem (and I just tried it now with Excel 2002).

--
Jim
"T Dragos" T wrote in message
...
| In Excel XP, I open two files from a local folder. Then I save (using
'Save
| As') the first file to a folder on a network share, when I try and save
the
| second file to a different folder on the same network share, Excel
saves
the
| second file to the folder the frst file was saved to. I can diplicate
this
on
| multiple machines on multiple domains. I have applied all updates. Is
there a
| way to stop this from happening? The only work around I have come up
with
is
| to close Excel between each 'Save As' attempt.

I am using Excel 2002 (10.6816.6817) SP3

The same version as I was using. Very strange as it does not happen for me,
as I said. Sorry I do not have an answer.

--
Jim
"T Dragos" wrote in message
...
|I can select the folder, and it appears to save the file, but when I go
| looking, the file is in the first folder. Again, the key seems to be the
| first "save as" location is sticking when I try the second "save as". I am
| using Excel 2002 (10.6816.6817) SP3
|
| "Jim Rech" wrote:
|
| when I try and save the second file to a different folder
|
| When you do the second Save As are you saying that Excel will not allow
you
| to select another folder? Or are you saying that, even though you can
| select another folder, Excel will not use it? I've have never run into
| either problem (and I just tried it now with Excel 2002).
|
| --
| Jim
| "T Dragos" T wrote in message
| ...
| | In Excel XP, I open two files from a local folder. Then I save (using
| 'Save
| | As') the first file to a folder on a network share, when I try and
save
| the
| | second file to a different folder on the same network share, Excel
saves
| the
| | second file to the folder the frst file was saved to. I can diplicate
this
| on
| | multiple machines on multiple domains. I have applied all updates. Is
| there a
| | way to stop this from happening? The only work around I have come up
with
| is
| | to close Excel between each 'Save As' attempt.
|
|
|

I wasn't doing this through code. One of my users just likes to open multiple
Excel Spread sheets at the same time and then save them to different
locations.

"Don Guillett" wrote:

Does this help?

Sub savefileasandcomeback()
originalpath = ActiveWorkbook.Path
MsgBox op
ActiveWorkbook.SaveAs Filename:= _
"YourPath\YourName.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ChDir originalpath
End Sub

--
Don Guillett
SalesAid Software

"T Dragos" wrote in message
...
I can select the folder, and it appears to save the file, but when I go
looking, the file is in the first folder. Again, the key seems to be the
first "save as" location is sticking when I try the second "save as". I am
using Excel 2002 (10.6816.6817) SP3

"Jim Rech" wrote:

when I try and save the second file to a different folder

When you do the second Save As are you saying that Excel will not allow
you
to select another folder? Or are you saying that, even though you can
select another folder, Excel will not use it? I've have never run into
either problem (and I just tried it now with Excel 2002).

--
Jim
"T Dragos" T wrote in message
...
| In Excel XP, I open two files from a local folder. Then I save (using
'Save
| As') the first file to a folder on a network share, when I try and save
the
| second file to a different folder on the same network share, Excel
saves
the
| second file to the folder the frst file was saved to. I can diplicate
this
on
| multiple machines on multiple domains. I have applied all updates. Is
there a
| way to stop this from happening? The only work around I have come up
with
is
| to close Excel between each 'Save As' attempt.