Re: Excel saves to wrong folder

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
dguillett1@xxxxxxxxxxxxx
"T Dragos" <TDragos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:92ED876B-1135-4001-A0BB-9475477284D2@xxxxxxxxxxxxxxxx
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 Dragos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B64E932F-87E3-464C-8DA2-4979BDD7D6E3@xxxxxxxxxxxxxxxx
| 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.





.

Relevant Pages

  • Re: How to delete the Personal and Practice Tabs in Excel
    ... As Gord Dibben suggests look at the XLSTART folder. ... workbook to open normally, which it does automatically if in the XLSTART ... Close Excel and at the prompt asking if you ... I think this is a BUG of this Brazilian Portuguese version. ...
    (microsoft.public.excel.programming)
  • Re: Re: Updating Excel Links
    ... My Word document consists of almost nothing more than a couple hundred Excel ... WHAT I'D LIKE -- the user stores both files in the same folder. ... Jean-Guy Marcil - Word MVP ...
    (microsoft.public.word.vba.general)
  • Re: Import from Excel
    ... "Peter Jamieson" wrote: ... even if you leave a copy of the Excel worksheet at the old location. ... folder, all that will happen is that Word will probably not find the data ... source when it next opens the .doc, and you will be prompted to locate it. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Modification date shouldnt be updating...
    ... > 10.1.5 and Excel 11.1.1 to test. ... > the network shares. ... > so i took a closer look on ACL and unix access rights in MacOSX 10.4.2 ... > a folder an the network share with the following ACL ...
    (microsoft.public.mac.office.word)
  • Re: Modification date shouldnt be updating...
    ... Client both had all the latest updates to Mac OS X, I Used Excel ... the network shares. ... so i took a closer look on ACL and unix access rights in MacOSX 10.4.2 ... a folder an the network share with the following ACL ...
    (microsoft.public.mac.office.word)