Results 1 to 5 of 5

Path for File Saving Defined by USER

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2007
    Posts
    58

    Path for File Saving Defined by USER

    Hi All,

    I have written the following code:

    Sub Macro1()
    
        Sheets("Finalsheet").Select
        Selection.AutoFilter Field:=1, Criteria1:="<>"
        Cells.Select
        Selection.Copy
        Workbooks.Add
        ActiveSheet.Paste
        Application.CutCopyMode = False
        ChDir "J:\HSS\SIV\2007"
        ActiveWorkbook.SaveAs Filename:= _
            "JJ:\HSS\SIV\2007\abc.txt", FileFormat:=xlText, _
            CreateBackup:=False
        ActiveWorkbook.Save
        ActiveWindow.Close
        End Sub

    This code save the new file in a pre-defined path and gives a particular name only...

    I want whenever user runs this macro.....they should get a Saving Option (As it is in Windows new file Save Option).


    Is it possible??/
    Last edited by VBA Noob; 09-20-2007 at 02:48 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1