Results 1 to 30 of 30

Read-Only file needs to be Save As to specific folder with Range Name

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    Minnapolis
    MS-Off Ver
    Excel 2010
    Posts
    31

    Read-Only file needs to be Save As to specific folder with Range Name

    I have to export excel statements that open as a Read-Only file, then save them with the name in cell A1 to a specific folder... I am getting closer I think, but when I try to run the macro the file does not save.... what have I done wrong?? I am using Excel 2010 and want to save to Excel Workbook or Excel 97-2003 Workbook

    Here is my code....

    Sub SaveAS()
    '
    ' SaveAs Macro
    '
    ' Keyboard Shortcut: Ctrl+a
    '
    
        ChDrive "H:"
        ChDir "\\mspm1bnas04\westc4"
        fullFileName = Application.GetSaveAsFilename(Range("A1"))
        If Filename <> False Then
            ActiveWorkbook.SaveAS " & fileName"
        End If
    End Sub
    Thank you!!
    Last edited by Cutter; 07-31-2012 at 06:07 PM. Reason: Added code tags

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