Results 1 to 4 of 4

Save As sub not saving

Threaded View

imatomic Save As sub not saving 12-31-2009, 05:00 PM
mikerickson Re: Save As sub not saving 12-31-2009, 05:17 PM
Leith Ross Re: Save As sub not saving 12-31-2009, 05:20 PM
imatomic Re: Save As sub not saving 12-31-2009, 05:48 PM
  1. #1
    Registered User
    Join Date
    01-07-2008
    Posts
    42

    Smile Save As sub not saving

    The dialog box comes up with file name formatted correctly and shows .xls as file type but when you choose save the dialog box disappears as if the file was saved but the file never gets saved. What am I doing wrong?

    Sub SaveAs()
        Dim TName As String
        Dim SvAs As String
        TechName = Range("N5").Value
        SvAs = Application.GetSaveAsFilename(InitialFileName:="Test Sheet for " & TName, FileFilter:="Excel Workbook (*.xls), *.xls", Title:="Save Workbook with Name")
    End Sub
    Thanks much for any help.
    Barry
    Last edited by imatomic; 12-31-2009 at 05:49 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