Results 1 to 3 of 3

Thread: [RESOLVED] Excel "Save as" with path?

Threaded View

  1. #1

    Thread Starter
    Lively Member adifel's Avatar
    Join Date
    Jan 2006
    Location
    California
    Posts
    103

    Resolved [RESOLVED] Excel "Save as" with path?

    I am using this sub to save the active workbook:

    Code:
    Private Sub FileSave()
      flFormat = ActiveWorkbook.FileFormat
      flName = Range("D5").Value & ".xls"
      flToSave = Application.GetSaveAsFilename(flName, filefilter:="Excel Files (*.xls), *.xls", _
        Title:="Save FileAs...")
      If flToSave = False Then
        Exit Sub
      Else
        ThisWorkbook.SaveAs Filename:=flToSave, FileFormat:=flFormat
      End If 'flToSave = False
    End Sub 'FileSave()
    but I can't figure out how to set the default directory to let's say "H:\Team A".

    As there are lots of team members using the same template, I cant set up the name with the path included (e.g. Application.ActiveWorkbook.SaveAs "H:\Team A\John\Item.xls").
    I found on the forums all kind of ideas, e.g. using ChDir, but none works.
    Any suggestions will be appreciated.
    Last edited by adifel; Oct 29th, 2008 at 01:03 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width