+ Reply to Thread
Results 1 to 3 of 3

Save As not working in 2010 but worked in 2003

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Texas, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Save As not working in 2010 but worked in 2003

    I have an estimate form created in Excel. I want to streamline the save as process so that it is easy for my user. It worked fine in 2007 but doesnot work in 2010. PLease help

    Code in 2007:

    Sub cmdSaveNClose()
    ThisWorkbook.SaveAs Range(B47) & Range(C15)
    ThisWorkbook.PrintOut
    ThisWorkbook.Close
    End Sub

    where B47 is the save as path and C15 is the save as file name. Works great in 2007. Nothing in 2010.

    Please Help!

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Save As not working in 2010 but worked in 2003

    You need to define your file format

    Please Login or Register  to view this content.

  3. #3
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Save As not working in 2010 but worked in 2003

    Are you saying you get no errors but your file is still not saved? That would be most peculiar.
    Did the code previously work in 2003 or 2007 - you mention both at different places in the question?
    Last edited by OnErrorGoto0; 01-04-2012 at 02:45 AM.
    Good luck.

+ Reply to Thread

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